Static Date & Time

**snaxxy** · 04-26-2012, 04:40 PM

Hi,

I am creating a '2nd tier help request form'. When the first user opens the workbook I want the date & time it was opened to be automatically put into a cell.

This will then be emailed to a 2nd tier support, and when they open the form I want them to see the original date & time the workbook was created by the original agent. So in other words, once the date/time was automatically populated I don't want it to change.

How is this possible?

Thanks!

Gary

**jeffreybrown** · 04-26-2012, 04:42 PM

In the ThisWorkbook module...

Please Login or Register  to view this content.

**snaxxy** · 04-26-2012, 04:51 PM

Hi Jeff,

Thanks, I'll try that. So I assume I change the "A1" to whichever cell I want to be populated?

Gary

**jeffreybrown** · 04-26-2012, 04:57 PM

Hi Gary,

Exactly, change A1 to suit your needs along with the sheet name. The if statement should also check the file for multiple openings. In other words, the first time you open the file then you would get the Date/Time, but when you open a second time, since there is already a Data/Time then this should not get overwritten.