FotoFan
09-17-2007, 03:16 PM
I'm new at Vb so please be gentle...
I need to create a date and time "serial Number" in Excel that will not change when the document is opened a second time. If I use the =NOW() function, the date will be auto entered but will change when I reopen the doc later. How do I lock this so once it is entered, it will remain as a record of when the doc was saved?
Thanks
I need to create a date and time "serial Number" in Excel that will not change when the document is opened a second time. If I use the =NOW() function, the date will be auto entered but will change when I reopen the doc later. How do I lock this so once it is entered, it will remain as a record of when the doc was saved?
Thanks