Macros and Passwords

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

When i attached a password to a file with a macro I get a security warning
and I can't make the macro work unless i save the file with no password.

Does anyone know a way to have both a macro and a password?
 
What version of Excel are you using? What *exactly* does the error message
say? What is you VBA Macro Security setting?


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting
www.cpearson.com
(email on the web site)
 
I'm using office 2007, the message bar says: security warning: macros have
been disabled but the options don't allow me to enable it, my macro option is
set to allow all but the macro only works if i remove the password
 
In Excel 2007, there are two different files formats. This is different than
2003 and earlier versions in which there was only one file format. Excel
2007 has "xlsm" files that can contain VBA code and "xslx" files that do not
allow VBA code. You must be sure that you are saving as an xslm file format.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting
www.cpearson.com
(email on the web site)
 
Yes i know. I saved it in "xlsm" format but the macro will only work if i
remove the password
 
--------------------------------------------------------------------------------------------------
Posted by Jim Reach.

"In Excel 2007, if you password protect your workbooks and they contain
macros, there is no way to enable macros."

Not "no way". There is a registry entry that turns this security feature
off.

HKEY_CURRENT_USER\Software\Microsoft\Office\12.0\Excel\Security\ExcelBypassEncryptedMacroScan

set to 1.
-----------------------------------------------------------------------------------------------------


Regards,
Shailesh Shah
http://in.geocities.com/shahshaileshs/
(Free addins Office Menu-2003 for Office-2007)
If You Can't Excel with Talent, Triumph with Effort.

Free Addins Office Menu-2003 for Office-2007
http://in.geocities.com/shahshaileshs/menuaddins
 
I have the EXACT same situation. How ridiculous that Microsoft does not in
anyway warn about this. I have wasted about 4 hours today trying to figure
this out. Thank you for this post though. At least I know now I am not
going crazy.
 
Can you tell me how to save an excel 2007 file without password protection?
The file was originally created in excel 2003 and the password was inherited.
I can't get rid of the password and until I do I cannot run macros. Thanks

Randy
 
Shah or Jim,

In the registry I can follow the path this far:
HKEY_CURRENT_USER\Software\Microsoft\Office\12.0\Excel\Security\
but after that the files do not seem to be there. There is a file with the
data set to 1, should i change it to a zero, or is in suppose to be 1. Any
help would be great.
 
Back
Top