Freezing the date &Trasferring values

**reeben** · 05-13-2009, 05:37 AM

Hi
I am a complete novice in Excel Macros so please don't think that I am insulting your intelligence by asking such a dumb question

I am trying to work on two things:

The first one is ,I want the date in a particular cell to remain fixed once I've finalized and saved the sheet.It shoudn't change if I open the worksheet after a couple of days.

The second one is to retrieve values form one sheet and display it as a summary in another sheet. (please see the attached excel sheet for more details)

Could someone please send me a bespoke macros for this please?

**mubashir aziz** · 05-13-2009, 05:47 AM

Where is the File ??????

**mubashir aziz** · 05-13-2009, 05:54 AM

Click Alt + F11 in your new work book and then on left side double click work book and paste this code .....

It will save Date & Time in column B1 before save and you will be able to see your last Save Date

Private Sub Workbook_BeforeSave(ByVal SaveAsUI As Boolean, Cancel As Boolean)

Sheets("Sheet1").Range("B1").Value = ThisWorkbook.BuiltinDocumentProperties("Last Save Time")

End Sub