MrExcel Consulting
Your One Stop for Excel Tips & Solutions

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

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.

Posted by Barrett South London NR Brixton on August 22, 2001 2:44 PM

Mess for Jill

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

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

Re: Mess for Jill

Eh? I don't get it.

Regards,
Dax.

Posted by Barrett on August 26, 2001 12:05 PM

Mess Dax + Jill

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