ExcelBanter - disable a macro using a macro

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - disable a macro using a macro (https://www.excelbanter.com/excel-programming/427155-disable-macro-using-macro.html)

Kashyap

disable a macro using a macro

how to disable a macro using a macro?

Barb Reinhardt

disable a macro using a macro

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?

Jacob Skaria

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?

All times are GMT +1. The time now is 05:12 PM.