Share via

Stop auto run Excel macro?

Anonymous
2011-11-23T21:03:21+00:00

Hello,

I have an Auto Run Excel file open every morning by Task Scheduler that calls up several Excel files to open and refresh data.

I need to open in edit and modify the Auto Run Excel file, how do I open in Edit mode, so it doesn't auto run? Thanks

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

4 additional answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2011-11-28T15:07:51+00:00

    Hans,

    I did tried the Run option, and it's still run my macro.

    I don't know what else to do. Is there a way to turn off add-ins so it doesn't load? Thanks

    Was this answer helpful?

    0 comments
  2. HansV 462.6K Reputation points
    2011-11-23T22:10:05+00:00

    Try this:

    Quit Excel.

    Click Start > Run...

    Type the following, then press Enter or click OK:

    "C:\Program Files\Microsoft Office\Office11\Excel.exe" /Automation

    This starts Excel without loading add-ins.

    Was this answer helpful?

    0 comments
  3. Anonymous
    2011-11-23T21:51:23+00:00

    Hi,

    I did tried the SHIFT key, but it popped up this message.

    Cannot open Microsoft Office Excel Add-In for editing. Please edit the source document instead.

    If I hit the Ok button, it will just run my macro.

    Is there problem with add-in?

    Was this answer helpful?

    0 comments
  4. HansV 462.6K Reputation points
    2011-11-23T21:05:33+00:00

    Hold down the Shift key while opening the workbook, and release it when the workbook has fully opened.

    Was this answer helpful?

    0 comments