adding current date then after saving the file current date function stops

is there any way to have L4 get the current date, but when saved the current date function stops.

Essentially, you want to add a timestamp?

In the ThisWorkbook module of the VBA code, use the following code:

Please Login or Register  to view this content.

Let me know if that helps.

As of right now it works. I changed the date on the computer to test it and its seems to work fine. Thank you so much.

Originally Posted by BigBas

Essentially, you want to add a timestamp?

In the ThisWorkbook module of the VBA code, use the following code:

Please Login or Register  to view this content.

Let me know if that helps.

ok one more question. What i do is i put this code into a template, then edit it to fit the job. Does this code update the date everytime i open then template or do i half to run the code for it to update.