Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 16
Default 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

  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 7,247
Default 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



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Bypass worksheet_change event Dr.Schwartz Excel Programming 3 May 27th 05 02:20 PM
Worksheet_change event. Mike K Excel Programming 8 October 24th 04 09:00 PM
Worksheet_change event Dwayne Smith Excel Programming 2 June 5th 04 03:25 AM
Worksheet_Change Event cmcfalls[_4_] Excel Programming 3 April 12th 04 09:47 PM
Worksheet_Change Event Sam Excel Programming 2 November 21st 03 06:51 PM


All times are GMT +1. The time now is 03:17 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"