Thread: disable a macro using a macro
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Jacob Skaria Jacob Skaria is offline
external usenet poster
  
Posts: 8,520
Default disable a macro using a macro
Kashya, just to add on ... please dont forget to set 'EnableEvents' to True
just before End Sub.

If this post helps click Yes
---------------
Jacob Skaria


"Barb Reinhardt" wrote:

If it's an event related macro, do this

Application.EnableEvents = False

HTH,
Barb Reinhardt

"Kashyap" wrote:

how to disable a macro using a macro?
Reply With QuoteReply With Quote