how can i protect a macro enabled file with a password so that unless you enter the password no one can open that file...i have tried "save as" option and in the general tools i entered the password...but now the problem is when i open the password protected file...macros stop working...every time it says to enable the macro in security settings...i have already enabled them but it still doesn't work...i am using excel 2007 and i am trying to save this file in xlsm format...
help please
help please