Force Worksheet_Change event

G

glen.e.mettler

I have a sheet that is updated via user input on another sheet. I do
this thru the Worksheet_Change event. Works well for any data change.
However, if the user changes the background color (via a menu option),
the Worksheet_Change event is not executed. How can I force the
Worksheet_Change event to execute when the user changes color?

Glen
 

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

force recalculation of function 5
Worksheet_Change after validation 6
Run VBA code only worksheet change, but don't trigger worksheet_change event based on what the code 6
Fire Worksheet_change event from module 3
MultiWorkbook Change Event Detection / Spell Checker 4
Can Worksheet_Change call itself? 6
Can Checkboxes trigger the Worksheet_Change code? 3
Data form not triggering Worksheet_Change event 3

Top