Frank that was a Formula rank one method.

Im able to do what I wanted.

Thanx a ton for helping day in and night out.

Regards,
Hari
India






"Frank Kabel" wrote in message
...
Hi
use Workbook_Open()
in the same module as your current BeforeSave macro is.
For more about these event procedures see:
http://www.cpearson.com/excel/events.htm

--
Regards
Frank Kabel
Frankfurt, Germany


Hari wrote:
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