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?
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
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.