Question when opening an excel speadhseet with multiple worksheets

[SUSAN]

We have several worksheets setup with different categories for fruit
industry. Is there a way when a user clicks on a worksheet that it can ask
them a question like Tangerine or Orange or Grapefruit so the user has to
click on yes or no to confirm that they are entering on the correct worksheet
as we have had some errors in the past

Thanks!!!

 

[Gord Dibben]

You can using sheet_activate event code, but they could just click yes even if
they activate the wrong sheet then where would you be?

How would you deal with that?

If they click no what happens next?

If they just close the message box without answering yes or no then what?


Gord Dibben MS Excel MVP

 

[smart]

We have several worksheets setup with different categories for fruit
industry. Is there a way when a user clicks on a worksheet that it can
ask
them a question like Tangerine or Orange or Grapefruit so the user has to
click on yes or no to confirm that they are entering on the correct
worksheet
as we have had some errors in the past

Thanks!!!