Archive of Mr Excel Message Board
Back to Dates in Excel archive index
Back to archive home
How can you show last saved date in a worksheet?Posted by Jill on August 22, 2001 8:52 AM
I am so stupid at this! I have to come up with someway to solve this problem or my boss is going to fire me! Can anyone help me? I would be very gratefull!
He wants me to show the last saved date on a worksheet. He is growing very inpatient and I don't want to have to sleep with him again to 'smooth' this over.
Re: How can you show last saved date in a worksheet?Posted by Dax on August 22, 2001 9:14 AM
He wants me to show the last saved date on a worksheet. He is growing very inpatient and I don't want to have to sleep with him again to 'smooth' this over. Jill
Give this a go. On the Excel icon (the on right next to File) right click and select View Code. Then use this code:-
Private Sub Workbook_BeforeSave(ByVal SaveAsUI As Boolean, Cancel As Boolean)
'Obviously change this to meet your requirements i.e. sheet name, cell
'and the date time format.
Sheets("Sheet1").Range("A1").Value = Format(Now(), "dd-mm-yy hh:mm")
Hope this helps,
Mess for JillPosted by Barrett South London NR Brixton on August 22, 2001 2:44 PM
Listen if hes you boss a thick couple of ears are due, Excellers all help..
Ask and Excellers will help.
Dont worry i help most my company and push people should try to DIY not pester others
Better ive said my bit. Do you have email??
I run a work help section if your intrested
Re: Mess for JillPosted by Dax from Elephant Castle, South East London on August 23, 2001 2:54 AM
Eh? I don't get it.
Mess Dax + JillPosted by Barrett on August 26, 2001 12:05 PM
Dax E+C boy cool. i was Walworth for a bit, East St, hey send Email ill miss out this Board.
Jill it refered to Ears...
This archive is from the original message board at www.MrExcel.com.
All contents © 1998-2004 MrExcel.com.
Visit our online store
to buy searchable CD's with thousands of VBA and Excel answers.
Microsoft Excel is a registered trademark of the Microsoft Corporation.
MrExcel is a registered trademark of Tickling Keys, Inc.