Hello:

I am creating Excel 2007 workbooks from Access 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