Thread: CANCEL EVENTS
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Jim Thomlinson Jim Thomlinson is offline
external usenet poster
 
Posts: 5,939
Default CANCEL EVENTS

Application.enableevents = false
Application.enableevents = true

You should use an error handler with this type of code to ensure that in the
case of crash the events are turned back on...
--
HTH...

Jim Thomlinson


"whylite" wrote:

Hi I am running a macro that causes another macro to occur. This causes an
error. What I would like to do is run the macro while leaving all other
macros disables until the current macro is finished executing. Any help
would be appreciated.
--
Thanks!
Shane W