Recalulate on format change...
 

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

Recalulate on format change...
 

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


"J S" wrote in message
...
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

Recalulate on format change...
 

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
--
Message posted from http://www.ExcelForum.com