| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Locking =Today() on Save as on Template
Hi Folks,
I have a Excel Template with a =today() cell to show todays date when opened - but would like have the date shown when the file was saved, not todays date? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Locking =Today() on Save as on Template
Hi,
Use Ctrl+; which gives a non-volatile date. Mike "Ross Thomson" wrote: Hi Folks, I have a Excel Template with a =today() cell to show todays date when opened - but would like have the date shown when the file was saved, not todays date? |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Locking =Today() on Save as on Template
Control semi-colon
-- David Biddulph "Ross Thomson" wrote in message ... Hi Folks, I have a Excel Template with a =today() cell to show todays date when opened - but would like have the date shown when the file was saved, not todays date? |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Locking =Today() on Save as on Template
Private Sub Workbook_BeforeSave(ByVal SaveAsUI _
As Boolean, Cancel As Boolean) If ThisWorkbook.Path = "" Then Sheets("Sheet1").Range("A1").Value = "Last Saved On " & _ Format(Date, "mm/dd/yyy") End Sub Placed in Thisworkbook module of the Template which I assume is a true *.XLT template Gord Dibben MS Excel MVP On Thu, 9 Oct 2008 21:57:36 +1300, "Ross Thomson" wrote: Hi Folks, I have a Excel Template with a =today() cell to show todays date when opened - but would like have the date shown when the file was saved, not todays date? |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Locking =Today() on Save as on Template
Forgot the End If
End If End Sub Gord On Thu, 09 Oct 2008 14:36:21 -0700, Gord Dibben <gorddibbATshawDOTca wrote: Private Sub Workbook_BeforeSave(ByVal SaveAsUI _ As Boolean, Cancel As Boolean) If ThisWorkbook.Path = "" Then Sheets("Sheet1").Range("A1").Value = "Last Saved On " & _ Format(Date, "mm/dd/yyy") End Sub Placed in Thisworkbook module of the Template which I assume is a true *.XLT template Gord Dibben MS Excel MVP On Thu, 9 Oct 2008 21:57:36 +1300, "Ross Thomson" wrote: Hi Folks, I have a Excel Template with a =today() cell to show todays date when opened - but would like have the date shown when the file was saved, not todays date? |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Locking =Today() on Save as on Template
Thanks Folks, - works a treat
Ya saved my bacon "Gord Dibben" <gorddibbATshawDOTca wrote in message ... Forgot the End If End If End Sub Gord On Thu, 09 Oct 2008 14:36:21 -0700, Gord Dibben <gorddibbATshawDOTca wrote: Private Sub Workbook_BeforeSave(ByVal SaveAsUI _ As Boolean, Cancel As Boolean) If ThisWorkbook.Path = "" Then Sheets("Sheet1").Range("A1").Value = "Last Saved On " & _ Format(Date, "mm/dd/yyy") End Sub Placed in Thisworkbook module of the Template which I assume is a true *.XLT template Gord Dibben MS Excel MVP On Thu, 9 Oct 2008 21:57:36 +1300, "Ross Thomson" wrote: Hi Folks, I have a Excel Template with a =today() cell to show todays date when opened - but would like have the date shown when the file was saved, not todays date? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| When you hit Save on a template, how can you save as worksheet? | Excel Worksheet Functions | |||
| Locking documents in Excel after a template has been created. | Excel Worksheet Functions | |||
| locking template? | Excel Discussion (Misc queries) | |||
| Using today formula for a template | Excel Discussion (Misc queries) | |||
| How and where to save template? | Excel Discussion (Misc queries) | |||
Linear Mode
