So if you set the Trust Center macro security option back to Disable with
Warning, do you not get a Security Warning bar appearing above the formula
bar? This should allow you to enable the macros.

--
Jim
"Rob" wrote in message
...
| Wow, what a confusing change Excel 2007 is over its predecessors!!
|
| My main battle is trying to get macros to run after saving to the new
| format.
|
| The macros run fine if I open as an xls, but if I save as xlsm and try to
| run the macros I get a message stating that the macros may not be
available
| or may be disabled. I checked, and the macros are still there but I can't
| run them.
|
| When I first installed Office 2007 I used to get a message warning about
the
| macros and giving me options to allow, etc., but that warning never
appears
| anymore. I suspect after I went into the Trust Centre and set the option
to
| enable all macros things went south after that. I checked all the
security
| settings, etc., but I never get a warning about macros. They are just
| disabled (unless I leave it as an xls file).
|
| Please help. I don't want to uninstall and reinstall. I did try the
repair
| option which made no difference.
|
| Rob
|
|
|