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 Shailesh" wrote:

--------------------------------------------------------------------------------------------------
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\E xcel\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





"Shawrie777" wrote in message
...
Yes i know. I saved it in "xlsm" format but the macro will only work if i
remove the password

"Chip Pearson" wrote:

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)

"Shawrie777" wrote in message
...
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

"Shawrie777" wrote:

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?