Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Preventing Excel Auto_Open() Macro runnng on vpc -Holding "Shift" doesn't work
Hi I have recently migrated to VPC 2007 running XP pro with Office 2003 On my old native XP box (not vpc) I could prevent Auto_Open Macros from running by holding down shift key while opening the workbook containing the macro I have thought of checking the workbook location folder and if location is indeed the designated "development folder" then exiting the macro BUT the macros in the book use other files so this is not good for testing unless I recreate a whole nest of directories and I also considered disabling Macros in Security (-not very elegant to say the least) can anyone point me in the right direction for a fix or a better workaround. Many thanks in advance! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
2007 - Column unhide in Excel does not work i.e. "Ctrl+shift+)" | Excel Discussion (Misc queries) | |||
Can I have "Shift-Click" or "Ctrl-Click" Code on Form List? | Excel Programming | |||
Holding Shift to bypass Auto_Open doesn't work in Excel 2007... | Excel Programming | |||
How 2 use right shift "<<" and left shift "" operator in excel? | Excel Programming | |||
Insert 19 cells "Shift to the right" if cell contains "-" | Excel Programming |