Hi,

Im few hours old with VBA.

I have a workbook in which I have a sheet by the name "Report Data" . In the
cell A3 of this sheet I want the person who saves this worksheet to indicate
the date for which the data in rest of the worksheets is current. It might
happen that the person who worked on this sheet didnt update the date and
the sheet got saved with the date of last save.

To prevent the same I want a macro which will execute automatically on
opening the workbook. This macro will clear the contents in cell A3.

I have already got another macro ( written by someone for me)
Workbook_BeforeSave which does some other things. Im thinking that once the
A3 cell can be made automatically blank then in Beforesave function I will
check for whether cell A3 is blank and hence not save the file. This will
flag the person who updates the workbook to enter the correct date in A3

I searched the MS Visual basic help for a function like AfterOpen but
couldnt find what Im looking for ..

Please guide me.

Regards,
Hari
India