| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Disable event macro while Auto_open() run
New at this so discription may be wrong
Is it possible to disable an event macro (Macro in sheet 1) while Auto_Open macro (in module) is running. i.e excel file is opening. one way might be to check which macro triggered the event macro. !!! Sunil |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Disable event macro while Auto_open() run
The easiest way is to surround your code with this:
Sub xxx() Application.EnableEvents = False ' your code in here Application.EnableEvents = True End Sub -- steveB Remove "AYN" from email to respond "Sunil Patel" wrote in message ... New at this so discription may be wrong Is it possible to disable an event macro (Macro in sheet 1) while Auto_Open macro (in module) is running. i.e excel file is opening. one way might be to check which macro triggered the event macro. !!! Sunil |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Disable event macro while Auto_open() run
Sub Auto_Open()
On Error goto ErrHandler Application.EnableEvents = False ' current code ErrorHandler: Application.EnableEvents = True End Sub -- Regards, Tom Ogilvy "Sunil Patel" wrote in message ... New at this so discription may be wrong Is it possible to disable an event macro (Macro in sheet 1) while Auto_Open macro (in module) is running. i.e excel file is opening. one way might be to check which macro triggered the event macro. !!! Sunil |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Disable SelectionChange Event | Excel Discussion (Misc queries) | |||
| Disable Auto_Open with VBA | Excel Programming | |||
| how to disable listbox change event | Excel Programming | |||
| Excel 2004 Can't Disable Auto_Open Macro. What Now? | Excel Programming | |||
| Disable Change Event in Form | Excel Programming | |||
Hybrid Mode
