View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
kraljb[_5_] kraljb[_5_] is offline
external usenet poster
 
Posts: 1
Default Events... Changing the Interior Color


I have a macro that is superfluous in nature, but basically all it does
is allow the user to edit the header colors with ease. Anyway, I have
been trying to find if there is an event for when someone just changes
the color of a cell.

The Worksheet_Change does not apply for just a color change, and I
could use the Worksheet_SelectionChange, but that returns the cell that
they moved to, not the cell they were at.

Does anyone have any suggestions? Or am I SOL?

Thank you in advance,
-John


--
kraljb
------------------------------------------------------------------------
kraljb's Profile: http://www.excelforum.com/member.php...fo&userid=9955
View this thread: http://www.excelforum.com/showthread...hreadid=387760