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

There's no event that will fire when your formatting changes.

You maybe able to use the worksheet_calculate event and keep track of colors so
you can compare them after each calculation.



kraljb wrote:

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

--

Dave Peterson

Create a toolbar button that throws up a colour picker, an d use that to set
the header colours. You then know a format change is happening.

--
HTH

Bob Phillips

"Dave Peterson" wrote in message
...
There's no event that will fire when your formatting changes.

You maybe able to use the worksheet_calculate event and keep track of
colors so
you can compare them after each calculation.



kraljb wrote:

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

--

Dave Peterson