| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Can I Add the last saved Date to cell ref in excel?
Hi anyone
How can I add the last saved date to a cell ref in excel? Thank you in advance -- Angela |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Can I Add the last saved Date to cell ref in excel?
Hi,
Alt+F11 to open Vb editor. Double click 'This Workbook' and paste this in Private Sub Workbook_BeforeSave(ByVal SaveAsUI As Boolean, Cancel As Boolean) Worksheets("Sheet1").Range("A1").Value = Now End Sub Mike "Angela" wrote: Hi anyone How can I add the last saved date to a cell ref in excel? Thank you in advance -- Angela |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Can I Add the last saved Date to cell ref in excel?
Thanks for replying Mike. Should I also add =lastsave() to A1 cell of Sheet1?
-- Angela "Mike H" wrote: Hi, Alt+F11 to open Vb editor. Double click 'This Workbook' and paste this in Private Sub Workbook_BeforeSave(ByVal SaveAsUI As Boolean, Cancel As Boolean) Worksheets("Sheet1").Range("A1").Value = Now End Sub Mike "Angela" wrote: Hi anyone How can I add the last saved date to a cell ref in excel? Thank you in advance -- Angela |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Can I Add the last saved Date to cell ref in excel?
Hi,
You can add whatever text you want, the correct syntax is Worksheets("Sheet1").Range("A1").Value = "Last saved date " & Now Mike "Angela" wrote: Thanks for replying Mike. Should I also add =lastsave() to A1 cell of Sheet1? -- Angela "Mike H" wrote: Hi, Alt+F11 to open Vb editor. Double click 'This Workbook' and paste this in Private Sub Workbook_BeforeSave(ByVal SaveAsUI As Boolean, Cancel As Boolean) Worksheets("Sheet1").Range("A1").Value = Now End Sub Mike "Angela" wrote: Hi anyone How can I add the last saved date to a cell ref in excel? Thank you in advance -- Angela |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Put Date Worksheet last saved in cell | Excel Discussion (Misc queries) | |||
| Populating Last Saved Date in Cell AND also update that same cell in Header | Excel Discussion (Misc queries) | |||
| ? on "date last saved" in cell | Excel Worksheet Functions | |||
| Inserting the date that an excel sheet is saved into a cell | Excel Discussion (Misc queries) | |||
| Last saved date into an excel cell | Excel Worksheet Functions | |||
Linear Mode
