Excel Macro-Enabled workbook (.xlsm) macros disabled and no obvious way to re-enable

Question

I'm having trouble with Excel macros being disabled in a macro-enabled workbook. I have an Excel 2003 template file (.xlt) that includes macros. I then do the following:

1. Open the Excel 2003 macro enabled template workbook (.xlt) in Excel 2007/2010
2. Save the workbook as an Excel 2007 macro-enabled workbook (.xlsm)
3. Close and open the workbook in Excel 2007/2010

Then the macros are disabled and there is no obvious way to enable them.

The same problem seems to be described here: http://www.sqldrill.com/excel/miscellaneous-excel-subjects/872432-excel-2007-macros.html

I’ve tried saving to a ‘trusted location’ and the other suggestions in that thread but the same problem occurs.

Has anyone else come across this problem?

Thanks, Tom

Answer 1

from developer tab

1. Macro Security a. macro setting : Select disable all macros with notification b. Developer Macro Setting: Select "Trust access to VBA Project Object model"
2. Disable Design mode
3. close and reopen the xlsm
4. it will prompt to enable macro content, click yes
5. Thats all, your macro is runnning now.

Answer 2

I had a similar problem - macros were not working, none of my events fired, etc. Closing/reopening had no effect.

By opening another workbook with macros enabled and running some of them, my problem workbook mysteriously began working again.