Date stamp onto Worksheet

[Bowdlerb]

I have an Excel Spreadsheet that I would like the date it is first opened to be inserted into a cell. I do not want the date to be updated if the file is subsequently opened and/or saved.
Is there a way I can do this?
Regards,
Barrie Bowdler

 

[nbrcrunch]

I'm a bit confused by this. If you have this spreadsheet already, then it has already been opened. So any subsequent opening will never be recorded per your requirements.

Are you talking about opening a blank, new spreadsheet?

 

[Zack Barresse]

you could write a macro, store it in your personal.xls file (in a module), assign it to a button, and then call it when you open the desired sheet.

hope i've not misread.

 

[DaVinci]

Recommend using an "Autpen" macro to check and see if the target cell is blank, and if so, place the current date there. Once the date occupies the cell, it will not be changed again.

Yes, the requirement is a little cloudy. *G*

 

[Iridium]

Adding to what's already been said is this any use?

Private Sub Workbook_Open()
If [a1].Value <> "" Then Exit Sub
   [a1].Value = Format(Now, "dd/mm/yy hh:mm:ss")
End Sub

To use the code whilst in xl hit Alt+F11. On the left hand side you should see the project explorer window (if not hit Ctrl+R). You should see your workbook listed as VBAProject (yourworkbook name) - double click on the ThisWorkbook module. Paste the code into this.

HTH