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.
Jill

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

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")
End Sub

Hope this helps,
Dax.


Mess for Jill

Posted 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 Jill

Posted by Dax from Elephant Castle, South East London on August 23, 2001 2:54 AM

Eh? I don't get it.

Regards,
Dax.


Mess Dax + Jill

Posted 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...

Rdgs





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.