Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Shift key doesn't stop Auto_Open() from firing
I have an Excel workbook that is opened from another program. The workbook
has an Auto_Open macro to perform several tasks each time it is opened. When I am trying to work on the code, it seems that holding down the Shift key when I open the workbook does not prevent the macro from executing automatically. I thought that in the past holding Shift had always prevented the code from running. Has anyone else run into this or know how to get it working again? -- ....jeff... -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=- |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Shift key doesn't stop Auto_Open() from firing
Jeff,
Posting your code would help, but try setting the Excel Object's EnableEvents property to false prior to opening the file, and set it back to true after... HTH, Bernie MS Excel MVP "Jeff Hunt" wrote in message ... I have an Excel workbook that is opened from another program. The workbook has an Auto_Open macro to perform several tasks each time it is opened. When I am trying to work on the code, it seems that holding down the Shift key when I open the workbook does not prevent the macro from executing automatically. I thought that in the past holding Shift had always prevented the code from running. Has anyone else run into this or know how to get it working again? -- ...jeff... -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=- |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Stop Active Cell from Firing Event after Hitting Return | Excel Programming | |||
Holding Shift to bypass Auto_Open doesn't work in Excel 2007... | Excel Programming | |||
How to stop UDF firing when sheets(n).calculate | Excel Programming | |||
Stop Worksheet_SelectionChange event from firing? | Excel Programming | |||
class events stop firing with ADO 2.8 | Excel Programming |