Disabling WORKSHEET_CHANGE event

  • Thread starter Thread starter Jase
  • Start date Start date
J

Jase

Is there a way to temporarily disable a sub worksheet_change()? I was
thinking of something along the lines of.... application.wokrsheet_change =
false and then run a macro that makes a bunch of changes to my sheet and then
make it true again? I know this method does not work but I was hoping there
is something along the lines of this out there.

thanks,

Jase
 
application.enableevents = false
'do the work
application.enableevents = true

But it disables all events--not just the worksheet_change event.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel How to run multiple Private Sub Worksheet_Change(ByVal Target As Range) 0
Can Worksheet_Change run from separate module? 7
Excel Worksheet_change with 2 functions to insert date and hyperlink window 0
two consecutive maros 8
Worksheet_SelectionChange & Worksheet_Change results in different Targets 2
VB Coding 1
Creating a spreadsheet with mandatory fields 0
REPSOT?? Sub Worksheet_Change(ByVal Target As Range) 14

Back
Top