LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
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

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
produce list automatically from choice of drop down list David Excel Discussion (Misc queries) 1 March 8th 10 07:15 PM
list choice depending on the value in another cell James New Users to Excel 1 August 27th 09 03:44 PM
Create a RowSource Depending on ComboBox Choice Blobbies Excel Discussion (Misc queries) 3 November 18th 07 01:22 AM
Creating a List based on your choice from Another List Cristi Excel Discussion (Misc queries) 1 August 14th 06 06:00 PM
Show pictures in excel depending of a choice! petterss Excel Discussion (Misc queries) 1 August 2nd 06 11:45 AM


All times are GMT +1. The time now is 11:26 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"