Saving / Password protecting Macro-Enabled work book
Hi All,
I Have a macro enabled workbook and i am trying to set it that only people with the password can open the file, I can set the password for modifying the file but when i set it for opening the file, i get this message;
"This workbook contains Excel 4.0 macros or Excel 5.0 modules. If you would like to password protect or restrict permission to this document, you need to remove these macros."
But i cannot remove these macros as they are integral to the sheet...!!!
Please help!!!
Last edited by tim_chisman; 01-24-2011 at 11:42 AM.
Is it saved as .xlsm?
Hope that helps.
RoyUK
--------
For Excel Tips & Solutions, free examples and tutorials why not check out my web site
Free DataBaseForm example
i am having the same problem. i had to convert the file from an .xls to an .xslm in order to get it to open in Excel 2010. But after converting it i am unable to password protect it to prevent it from being opened.
Any suggestions ?
bump please help...
yes file is xlsm...
saved file as xls and now works!!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks