Geek asks and answers

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

I'm having trouble disabling Excel macros in a macro-enabled workbook. I have an Excel 2003 (.xlt) file that includes macros. Then I do the following:

  • Open an Excel macro-enabled workbook with Excel 2003 support (.xlt) in Excel 2007/2010
  • Save the workbook as a workbook with Excel 2007 macro support (.xlsm)
  • Close and open workbook in Excel 2007/2010

Macros are then 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

Ive tried to keep the "trusted location" and other suggestions in this thread, but the same problem occurs.

Anyone else run into this problem?

Thanks Tom

+3
source share
5 answers

from the developer tab

  • Macro Security a. macro setting: select disable all macros with notification b. Developer Macro Setup: Select "Trust access to the VBA project object model"
  • Disable development mode
  • close and reopen xlsm
  • it will suggest to enable macro content, click yes
  • That's it, your macro is running now.
+2
source

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

, .

+1

Trust Center → Macro Settings, "Disable..." ( ). " ", , .xlsm (, , " " ).

0

, . - > disck cleanup,

0

Macro Security, @IndrajeetK, , VBA.

  • Go to: Windows> Start> Control Panel>Programs and Features
  • Select Microsoft Office (edition\version)
  • Click Change
  • Select Add or Remove Features
  • Click Continue
  • Go to: Microsoft Office> Office Shared Features>Visual Basic for Applications
  • Select the drop-down list and select Run from My Computer
  • Click Continue

If you still have problems, repeat the above, select Repairinstead Add or Remove Features.

If the above gives you a message configuration did not complete successfully, see this message in the journal investigation .

0
source

More articles:


All Articles