Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
disabling Auto_Open macros
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? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
disabling Auto_Open macros
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? |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
disabling Auto_Open macros
For the shift key to work you need to to open the file from within Excel.
Don -- "Malone" wrote in message ... 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? |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
disabling Auto_Open macros
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 "Don Lloyd" wrote in message ... For the shift key to work you need to to open the file from within Excel. Don -- "Malone" wrote in message ... 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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Does Disabling Macros affect Hyperlinks | Excel Discussion (Misc queries) | |||
Disabling macros | Excel Discussion (Misc queries) | |||
Disabling macros with Shift+[OPEN] | Excel Programming | |||
Enabling/Disabling Macros | Excel Programming | |||
Auto_Open disabling | Excel Programming |