View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
anar_baku[_17_] anar_baku[_17_] is offline
external usenet poster
 
Posts: 1
Default 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