| Home |
| Search |
| Today's Posts |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
I want to display the last file save date in an excel spreadsheet
Hi,
Alt+F11 to open VB editor. Double click 'This Workbook' and paste this in on the right. Change the sheet and column to suit Private Sub Workbook_BeforeSave(ByVal SaveAsUI As Boolean, Cancel As Boolean) lastrow = Sheets("Sheet1").Cells(Rows.Count, "A").End(xlUp).Row Cells(lastrow + 1, 1).Value = "Last saved " & Now End Sub Mike Mike "Export Waypoints from S&T ''06" wrote: Is it possible to display the last file save date in an excel spreadsheet like one can in Word? D2 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| save excel 2007 spreadsheet as a .wk1 file? | Excel Worksheet Functions | |||
| Excel 2007 - Save as a 123 or Lotus spreadsheet file? | Excel Discussion (Misc queries) | |||
| Can I write an excel formula to display the file save date? | Excel Worksheet Functions | |||
| How do I display the last saved date in an EXCEL spreadsheet? | Excel Discussion (Misc queries) | |||
| save excel spreadsheet as a csv file | Excel Worksheet Functions | |||
Threaded Mode
