Recalulate on format change...

[J S]

Is there anyway to write code so that all formulas on a sheet will get
automatically recalculated when a user changes the textcolor of any cell on
the worksheet?

Is there a onFormatChange event of any kind?

-J

 

[Chip Pearson]

JS,

I don't believe there is any way to do this.


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

 

[KJTFS]

Well.... It can be done but it is a little hard I have attached
workbook with it being done. Look at the MainS sheet in VBE.

Keith
www.ktjfs.co

Attachment filename: textcolorevent.xls
Download attachment: http://www.excelforum.com/attachment.php?postid=40650