Hi All,

I have a workbook with many worksheets. I want to hide all of them but one. The visible sheet will have a dropdown list with a list of choices that the user can select. Depending on their selection I want the appropriate worksheet to become visible and active. Can anyone suggest how I can do this?

Many thanks in advance.

Anar