You use the term "specific sheets to appear"

Are multiple sheets referenced by the chosen category?

Only one sheet can be visible at once unless you have multiple windows open
with a sheet in each window.

Or do you mean each category is linked to one sheet and you would like that
sheet to be selected/activated?


Gord Dibben MS Excel MVP


On Thu, 5 Mar 2009 09:36:02 -0800, Willco3
wrote:

I have created a drop-down menu in which specific categories are linked to
additional sheets in the workbook. When a category in the drop-down menu is
selected I want the specific sheets related to that category to appear - how
do I do this? I can find ways to have additional drop-downs pop up on the
same sheet but not separate worksheets. Thanks