Excel Sheet Timestamp
 

How do I insert a timestamp for the last time a sheet was saved? I've looked
at the NOW and TODAY functions, but these change each time I open the sheet.
I only want the formula to change IF I save the sheet. Can anyone offer any
suggestions?

Excel Sheet Timestamp
 

On Mon, 16 Oct 2006 09:37:02 -0700, DRK
wrote:

How do I insert a timestamp for the last time a sheet was saved? I've looked
at the NOW and TODAY functions, but these change each time I open the sheet.
I only want the formula to change IF I save the sheet. Can anyone offer any
suggestions?

In Workbook BeforeSave event put

Range("MyTimeStamp") = Time


HTH
__
Richard Buttrey
Grappenhall, Cheshire, UK
__________________________

Excel Sheet Timestamp
 

DRK wrote:
How do I insert a timestamp for the last time a sheet was saved? I've looked
at the NOW and TODAY functions, but these change each time I open the sheet.
I only want the formula to change IF I save the sheet. Can anyone offer any
suggestions?

are you looking for VBA code or a formula?

AR

Excel Sheet Timestamp
 

Place this code in the "ThisWorkbook" Module.

To get to VBA, Hit Alt-F11


Private Sub Workbook_BeforeSave(ByVal SaveAsUI As Boolean, Cancel As _
Boolean)
Range("d1") = Now
End Sub

ducky wrote:
DRK wrote:
How do I insert a timestamp for the last time a sheet was saved? I've looked
at the NOW and TODAY functions, but these change each time I open the sheet.
I only want the formula to change IF I save the sheet. Can anyone offer any
suggestions?

are you looking for VBA code or a formula?

AR

Excel Sheet Timestamp
 

Hopefully a formula...I'd like to include it in a cell.

"ducky" wrote:


DRK wrote:
How do I insert a timestamp for the last time a sheet was saved? I've looked
at the NOW and TODAY functions, but these change each time I open the sheet.
I only want the formula to change IF I save the sheet. Can anyone offer any
suggestions?

are you looking for VBA code or a formula?

AR

Excel Sheet Timestamp
 

Hi

You can't use a formula (as it will change each time as you have found).
That is why others have suggested a VBA solution to provide the date or
timestamp..
If you want to enter to a cell manually, then

To enter Date into a cell type Ctrl + ; - that's Control + semicolon
To enter Time into a cell type Ctrl + : - that Ctrl + colon or Ctrl
+ Shift + semicolon
--
Regards

Roger Govier


"DRK" wrote in message
...
Hopefully a formula...I'd like to include it in a cell.

"ducky" wrote:


DRK wrote:
How do I insert a timestamp for the last time a sheet was saved?
I've looked
at the NOW and TODAY functions, but these change each time I open
the sheet.
I only want the formula to change IF I save the sheet. Can anyone
offer any
suggestions?

are you looking for VBA code or a formula?

AR

Excel Sheet Timestamp
 

I see. Thanks, this looks like it works!

"Roger Govier" wrote:

Hi

You can't use a formula (as it will change each time as you have found).
That is why others have suggested a VBA solution to provide the date or
timestamp..
If you want to enter to a cell manually, then

To enter Date into a cell type Ctrl + ; - that's Control + semicolon
To enter Time into a cell type Ctrl + : - that Ctrl + colon or Ctrl
+ Shift + semicolon
--
Regards

Roger Govier


"DRK" wrote in message
...
Hopefully a formula...I'd like to include it in a cell.

"ducky" wrote:


DRK wrote:
How do I insert a timestamp for the last time a sheet was saved?
I've looked
at the NOW and TODAY functions, but these change each time I open
the sheet.
I only want the formula to change IF I save the sheet. Can anyone
offer any
suggestions?

are you looking for VBA code or a formula?

AR

Excel Sheet Timestamp
 

"DRK" wrote in message
...
How do I insert a timestamp for the last time a sheet was saved? I've
looked
at the NOW and TODAY functions, but these change each time I open the
sheet.
I only want the formula to change IF I save the sheet. Can anyone offer
any
suggestions?
Personnally I use
date with time (ctrl+semicolon)(space)(ctrl+Shift+colon)
Apply what ever format you want