Share via

Macro is disabled?

Anonymous
2013-09-12T14:08:49+00:00

I am trying to run a report that has worked in the past. Now when I try to run it I receive an error message stating:

Run-time error '2538':

The "l" macro action cannot be run in disabled mode.

Any suggestions?

Thank you.

Microsoft 365 and Office | Excel | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

7 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2013-09-12T17:17:52+00:00

    I did the first time I opened it, and clicked "Enable", but still had the same problem. Now when I open the report I don't have that option anymore

    1 person found this answer helpful.
    0 comments
  2. Anonymous
    2013-09-12T17:47:51+00:00

    Sorry I didn't explain properly, go to save as and where you see Save as Type, click in the arrow and you will see the option "Excel Macro-Enable workbook"

    0 comments
  3. Anonymous
    2013-09-12T17:34:54+00:00

    Not sure of what you mean. If I open the file, and go to Save As, there is no option macro enable. It just asks where/what to name the file.

    0 comments
  4. Anonymous
    2013-09-12T17:24:41+00:00

    try this open the file and then go to save us and choose the option macro enable

    0 comments
  5. Anonymous
    2013-09-12T15:44:43+00:00

    Hi, when you open the sheet do you see the word Enable where the formula bar is?, if yes click on it and try to run the macro

    0 comments