Macros not working in Excel 2007 workbooks

[rfooks]

Hello:

I am creating Excel 2007 workbooks from Access 2007 VBA using an
Excel
template (.xlsm) containing macros. When I create the workbooks w/o
applying password-protection to the Excel files, the macros run as
they are supposed to. However, when I save the .xlsm workbook with a
password, the macros do not run when I open the workbooks.


When I open the workbook, remove the password, and then close it..the
macros WILL run when I reopen the workbook. They don't run in a
password-protected workbook.


I have the 'Enable All Macros' option set in Trust Settings


Is this a known problem with Excel 2007??


Thanks,


Rick

 

[Steve Schapel]

Rick,

I think you will have a better chance of a good answer if you re-post
your question to an Excel-related newsgroup.

Regards
Steve