disabling Auto_Open macros

  • Thread starter Thread starter Malone
  • Start date Start date
M

Malone

I understand that depressing the shift key when opening an Excel file should prevent an Auto_Open macro from running. But I find it doesn't. Auto_Open macros run whether I am pressing the shift key or not.

Any suggestions?
 
Are you holding it down while the file opens?

You could open Excel and, using menus, go to Tools --> Macro -->
Security and set it up to ask you for permission to run the macro.
If you do not want to run auto open macros then you just reply to
the dialog box on opening the workbook with "Disable".

Chrissy.
www.home.gen.nz

PS - I see you are a Kiwi - or at least in Kiwi land.

Malone wrote
I understand that depressing the shift key when opening an Excel file should prevent an Auto_Open macro from running. But I find it
doesn't. Auto_Open macros run whether I am pressing the shift key or not.

Any suggestions?
 
For the shift key to work you need to to open the file from within Excel.

Don
--

I understand that depressing the shift key when opening an Excel file should
prevent an Auto_Open macro from running. But I find it doesn't. Auto_Open
macros run whether I am pressing the shift key or not.

Any suggestions?
 
Chrissy, Don thanks for your responses. Yes, it appears that holding down the shift key doesn't disable the auto_open macros from running if, like I do, you open an excel file by double clicking an icon. It doesn't matter whether an instance of Excel is already open or not. It seems the only way to prevent the auto_open macro from running using the shift key is to open the file from the file menu in Excel.

Malone
 
Back
Top