When Cell C7 is changed, it calls on the Private Sub Worksheet_Change(ByVal Target As Range) Macro.
Is it possible to block this macro during a particular other Macro's operation?
If so how would I go about it?
When Cell C7 is changed, it calls on the Private Sub Worksheet_Change(ByVal Target As Range) Macro.
Is it possible to block this macro during a particular other Macro's operation?
If so how would I go about it?
Yes,
Application.EnableEvents = False
Don't forget to renable in your code after the change is made.
Thanks jason, the line as true was in the Private Sub too.
I placed it where it need to be, worked great!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks