pop up boxes when a specific sheet is opened

[Chavira55]

I read the archives, but I can not find what I need. I would like for a box to pop up with a yes or no question when a sheet is opened. Any ideas?

 

[Yogi Anand]

On 2002-09-20 19:02, Chavira55 wrote:
I read the archives, but I can not find what I need. I would like for a box to pop up with a yes or no question when a sheet is opened. Any ideas?

Hi Chavira55:

If I understand you correctly, you waould like to have a message box pop up with a Yes / No question when a sheet is activated. I don't know why you want it this way, but you can do this with the following code for the sheet.

Private Sub Worksheet_Activate()
MsgBox "Yes / No"
End Sub

If it is Sheet3 that you want to associate this code with, then right click on Sheet3, then ViewCode, and then write the following code in the VBE.

There may be simpler ways of doing this, but one of the ways is to associate this code with every Sheet you would like to have work this way.

Regards!

Yogi
This message was edited by Yogi Anand on 2002-09-20 21:28

 

[Chavira55]

Thanks! I'll give it a shot. (The questions are to walk a user thru an scenario before doing computations)