Excel 2007 : Date change @ update only when file is save

[adzareena]

hi all,

I'm now in the middle of preparing a real time document. my boss asked me whether the date will only change when the excel document is updated or saved. if not, the date is remains as per the last update. pls help me...

[gjlindn]

Hello adzareena. I only know this is possible through use of VBA. In the Workbook Module add this:

Please Login or Register  to view this content.

In a each Sheet Module you want to monitor add

Please Login or Register  to view this content.

You can either name a range in your workbook MyDateRange or replace MyDateRange in the code with your cell reference. In the workbook module you would need to reference the sheet housing the time if you're using the cell address for the range. Example

Please Login or Register  to view this content.

If this is all jibberish to you, we could post a workbook example.

[adzareena]

tq..pls do post the workbook example...

[gjlindn]

Here it is...but I decided to modify it so the workbook/worksheet events call this routine located in a standard module.

Please Login or Register  to view this content.

Less code to put into each sheet if you need to add a worksheet change event to all sheets in your workbook.

[adzareena]

sorry, i'm still don't understand. what should i do with code? can i copy and paste it into the excel file?

[gjlindn]

The example attached in my last post already has the code in it. If you're unfamiliar with Excel macros continue reading. If you press the alt key along with F11 (ALT + F11) you'll get to the VBE (Visual Basic Editor). From there you should see the Project Explorer on the left where you will find worksheet and workbook objects (within the Microsoft Excel Objects folder) and Modules (in the Module folder). Double-clicking those will bring up their code in the main window area. That should be a good start for you.