If the workbook requires a password to open (in other words is encrypted so
Excel cannot scan it) Excel disables the macros.

--
Jim
"Johan U" <Johan wrote in message
...
One of my main Excel 2003 spreadsheet runs on macros I wrote. I installed
Excel 2007 today, loaded the file.xls on it, the macros run. After saving
in
file.xlsm and reloading, the macros don't run anymore. The message is:
"Because of your security settings, macros have been disabled. To run
macros, you need to reopen this workbook, and choose to enable macros."
I have set my macros at the lowest level in the 2007 trust center, as well
as in Excel 2003. When I reopen the workbook, there is no option to
"enable
macros"
Thanks for your help.