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?