Date Time Problem - stop updating that each time the document is opened

I have an excel sheet that when opened auto fills with todays date and time.
I need to find a way to NOT update that each time the document is opened after that. Even when I save the document each time I open it, it updates. This is not what a want. Can anyone help me?

Thanks in advance!

Originally Posted by royUK

If you have used =NOW or similar then it will update. What xactly are you doing?

What i am doing is using a an excel spreadsheet to Mark the start of a network outage and then extrapolate a time line of escalation from the opening of the document time. When i go back into the sheet to do other updates, the time has updated to the now time and messed up my escalation timeline.

If the worksheet is stored as a template (so that when you do the default action, New, you get a worksheet based on it), then the Open event can set the current date and time. Code goes in the ThisWorkbook module.

Please Login or Register  to view this content.

When you save the template, the range must be blank.

Thanks so much for the responses. I will give it a try.

dreammy