| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 __________________________ |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#8
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? | Excel Discussion (Misc queries) | |||
| Asked previously...can this not be done in excel | Excel Discussion (Misc queries) | |||
| Excel Sheet default setting. | Excel Discussion (Misc queries) | |||
| In Excel, how do you make one whole sheet equal to another. | Excel Discussion (Misc queries) | |||
| EXCEL FORMAT PROBLEM WHEN SENDING EXCEL SHEET AS MESSAGE BODY IN . | Excel Discussion (Misc queries) | |||
Linear Mode
