Disable event macro while Auto_open() run

  • Thread starter Thread starter Sunil Patel
  • Start date Start date
S

Sunil Patel

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
 
The easiest way is to surround your code with this:

Sub xxx()
Application.EnableEvents = False

' your code in here


Application.EnableEvents = True
End Sub
 
Sub Auto_Open()
On Error goto ErrHandler
Application.EnableEvents = False
' current code

ErrorHandler:
Application.EnableEvents = True
End Sub
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Auto_Open Code on Worksheet 2
Triggering auto_open 5
Bypass Auto_Open 13
Mysterious auto_open 1
Excel macro security fails in directory XLSTART. 6
Change file to read only 3
trying to replace auto_open with something like workbook_open 1
OnTime Change_Event macro AND copy to sheet2 macro trouble 7

Back
Top