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