Use the change event

See Chip Pearson's page on events
http://www.cpearson.com/excel/events.htm

--
Regards,
Tom Ogilvy


"All In" wrote:


I need to have the date in my excel spreedsheet change only when the
sheets are updated. I have 4 or more sheets per workbook and not all
sheets are not updated at the same time.


--
All In
------------------------------------------------------------------------
All In's Profile: http://www.excelforum.com/member.php...o&userid=36285
View this thread: http://www.excelforum.com/showthread...hreadid=560658