Force Worksheet_Change event
 

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

Force Worksheet_Change event
 

You can't.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


wrote in message
oups.com...
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