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

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

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

Hi Frank

Facing a Strange issue now.

I used the open code and before save code in conjunction and im able to make
sure that user doesnt enter data s/he isnt supposed to do. Also, Im able to
prevent the user from skipping/missing cells which are to be populated.

But Suppose I have some cells unfilled and/or some cells having incorrect
data and I choose the option "Send to Mail receipient as attachment" then
excel saves the incorrect/incomplete as a temporary file and attaches it to
my Lotus.

Please tell me whether there is a workaround to this and also why excel
allows it to send such a file as an attachement.

Regards,
Hari
India

"Hari" wrote in message
...
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