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
|