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