Hide Sheet depending on List choice
 

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


--
anar_baku
------------------------------------------------------------------------
anar_baku's Profile: http://www.excelforum.com/member.php...o&userid=18259
View this thread: http://www.excelforum.com/showthread...hreadid=541113