Simple error: List multiple sheet names in Workbook_SheetActivate event

Hi guys,

I hope you can help.

It should be something really simple.

I want a warning to appear when one activates certain sheets. I have tried the following, where I list the sheet names as follows:

Please Login or Register  to view this content.

But this gives me a Run-time error: 13 Type mismatch.

When a list a single sheet name as follows:

Please Login or Register  to view this content.

it works fine.

Here is my code:

Please Login or Register  to view this content.

Thank you!

Try change the line to:

Please Login or Register  to view this content.

And here's another alternative:

Please Login or Register  to view this content.

You may want to wrap it in application.enableevents = False and application.enableevents = True, in case you'd hide the DataBase or List-sheets during the procedure by pressing cancel (thereby triggerering a new event).

Hope this helps,
berlan