You might try putting your workbook in one of the Trusted Places specified
in the Trust Center.

--
Jim
"Harry G" wrote in message
...
|I just upgraded to Excel 2007 from Excel 2003. My macros (which include
| menus I added on the Excel Bar) do not open in Excel 2007.
|
| I noticed that the macro security has to be enabled. However when I do
that
| my custom menus on the Excel menu bar are not enabled.
|
| Could anybody help me to automate enabling the macros when I open my
| workbook. I do not want to save the file with enabled macros.
|
| Any help will be greatly appreciated.
|
| Thanks.
|
| Harry