Word of advice. You don't want this event to occur when opening. If you do,
then every time you open the file, it will display the time that it is
opened, not the time that changes were last made, as you said you wanted. You
want the time stamp to occur when the file is saved.

but that is just my 2 cents.
--
John C


"TJ" wrote:

Good day,

I have a spreadsheet where when this is opened I would like the time/date it
was opened to be static so I can know when the last changes were made.

I have created a macro button for paste special but is there away to do this
without clicking somewhere meaning as soon as the file is opened the time
/date gets stamped in a particulr cell without hitting save?

Appreciate anyone's help on this

thanks
TJ