Question when opening an excel speadhseet with multiple worksheets

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!!!

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


On Thu, 12 Jul 2007 13:52:02 -0700, SUSAN <SUSAN@discussions.microsoft.com>
wrote:

>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!!!

"SUSAN" <SUSAN@discussions.microsoft.com> wrote in message
news:CA5D2B92-DA44-4FB7-95BA-7E0BA39803EE@microsoft.com...
> 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!!!