ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Preventing Auto_Open() runnng on vpc -Holding "Shift" doesn't work (https://www.excelbanter.com/excel-programming/419879-preventing-auto_open-runnng-vpc-holding-shift-doesnt-work.html)

sirplus

Preventing Auto_Open() runnng on vpc -Holding "Shift" doesn't work
 
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!


All times are GMT +1. The time now is 11:15 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com