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"
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.
Yogi This message was edited by Yogi Anand on 2002-09-20 21:28