pop up boxes when a specific sheet is opened

Chavira55

Board Regular
Joined
Sep 19, 2002
Messages
65
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?
 

Excel Facts

Can a formula spear through sheets?
Use =SUM(January:December!E7) to sum E7 on all of the sheets from January through December

Yogi Anand

MrExcel MVP
Joined
Mar 12, 2002
Messages
11,454
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

Board Regular
Joined
Sep 19, 2002
Messages
65
Thanks! I'll give it a shot. (The questions are to walk a user thru an scenario before doing computations)
 

Forum statistics

Threads
1,144,741
Messages
5,726,016
Members
422,653
Latest member
mntsiki

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top