Code to show creation date & time

[Nicola13]

Hi,

I can use =now() to show the current date and time but obviously this chages each time the workbook is opened. I want a cell to show the creation date and time. Upon saving I do not want this date and time to change again. Is it possible to write code for this?

[stojko89]

Try inserting this macro in VBA Editor under This Workbook

Please Login or Register  to view this content.

[Nicola13]

This works if I put =now() into the cell but I want to save my workbook as a template. I want this cell to be blank then generate the current date time when the workbook is amended. Say a cell value changes for example. sorry if i did not make this clear enough in my first post.

[stojko89]

Then change the code to this:

Please Login or Register  to view this content.

THis inserts the date and time in cell A10