Suspend Execution

G

Guest

I need to suspend execution of a worksheet change event while another
procedure is running.

Can somebody remind me of the code for this.

Thanks, Kaval
 
N

Norman Jones

Hi Kaval

Application.EnableEvents = False

Call OtherProcedure

Application.EnableEvents = True
 

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

"Can't enter break mode at this time" error coming up 5
Suspending MAcros 1
how to Pause a VBA procedure until user presses Enter 15
Excel equivalent of Lotus {?} 5
Suspend old code while new code is running 1
threading help 2
Any ideas "can't enter break mode at this time" error gone amok 1
Excel VBA - Problem with Closing Print Preview 0

Top