View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Johan U Johan U is offline
external usenet poster
 
Posts: 1
Default Excel 2007 enabling macros

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.