Prevent Macro from running automatically (holding Shift doesn't wo

D

David

Hi all!
Following situation:
I have a workbook with the following macro:
Sub Auto_Open()
MsgBox "......"
Resize
MsgBox "....."
....
....
....
ThisWorkbook.Saved = True
Application.Quit
End Sub

If I want to prevent it from automatically, I hold down the shift key.
However, for some people this method doesn't work. Is anyone seen this?
Maybe related to a specific version of Excel, update...?
I don't want to go into more complicated workarounds
(Application.EnableEvents = false), or playing with the security level.

Any idea...?
Thanks in advance.
David
 
Top