Update Alert

T

Toan Chau

Hi all,

I was wondering if it is possible to create some type of
alert on an Excel sheet every time the Excel sheet has
been modified?

I was thinking of maybe a formula in a cell that gives the
date of the last time the Excel sheet was modified.

Is this possible?

A thousand thanks in advance.
 
D

David McRitchie

Hi Toan,
The Change worksheet event would tell you if you changed
a constant.
http://www.mvps.org/dmcritchie/excel/event.htm

And if you think about it, you wouldn't want to be told everytime a
formula with date and time changed the date and time with each
recalculation.

However, I think it would be a bad idea anyway because say you
try to update two cells, one right after another, I doubt that you
would want to be interrupted to have Excel tell you something you
knew you were doing.

To put the date, time, and cell changed in another sheet, you
could use Highlight Changes or the macro alternative also on
http://www.mvps.org/dmcritchie/excel/highlite.htm


Just placing timestamp into another cell (No Alert):
If you want to enter data in one specific column and have a datetime stamp
in another column (usually next column) you could use an event macro.
http://www.mvps.org/dmcritchie/excel/event.htm#datetimestamp
 
Top