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)

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