We saved a workbook we have used for years in xlsm format. Several really simple macros won't run. Many macros will.

We get run-time error '1004' Cannot run the macro 'Test'. The macro may not be available in this workbook or all macros may be disabled.

We click on the enable macro button when opening the workbook.

We also looked at options -> Macro security. No good.

We deleted all the code in the macto other than a msgbox. the macro will not run.

Any ideas would be greatly appreciated.

Thanks.