Stop Workbook_Open macro from running

[majosum]

Hello everybody,

I have a workbook_open event that automatically refreshes two data tables when the user opens the Excel document. The data it refreshes is fed into several graphs. The graphs are then linked to PowerPoint.

The problem I am encountering is that when I open the PowerPoint document to update the graphs, it automatically runs the Excel macro as well. I have six graphs, so it definitely increases the updating time when I have to wait for it to refresh the two tables six times each.

Does anybody know the code I can add to the beginning of the workbook_open event to prevent the rest of the code from running if the Excel document is opened through PowerPoint?

Thanks!

[Solus Rankin]

Hold the shift button while opening the document.

[HaHoBe]

Hi, Solus,

please explain how to hold the Shift-Button if the workbook is opened via Powerpoint. Iīd expect a hint on Application.EnableEvents = False but I donīt have a clue how Powerpoint should come in there to get that command to go.

Ciao,
Holger

[Solus Rankin]

when I open the PowerPoint document to update the graphs, it automatically runs the Excel macro as well

I assumed it was because of an open event handler which I thought could be disabled by holding Shift while opening.



e/ I shouldn't say open event, I thought holding shift temporarily disabled events.

[majosum]

Let me rephrase that. When I open the PowerPoint document that contains the graphs that are linked to Excel, it gives me two options: "Update Links" or "Cancel". I usually click "Update Links" and then it will continue to open and close the Excel document until all graphs are updated. It is at this point, when the Excel document opens multiple times, that I would like the macro to not completely run.

[Solus Rankin]

I'd say change your workbook open macro into a button or change the event. Sheet_Activate? Selection_Change?

I'm not sure what the macro is your spreadsheet is supposed to do.