Show one sheet, hide everything else with Combo Box

[blastpwr1970]

Hi everybody,

Could somebody help me, I need to select one sheet from a Combo Box activating it and hidding everything else.

I can do it with buttons but it will be nice, if I can do it with a Combo Box.

Is it possible to assign individual macros to individual lines in the combo box? if possible could somebody show me how!!

Thank you for all your help.

[lucas]

I've seen several methods of doing this but never with the hide all sheets except one. There happens to be a thread addressing this issuse...see here:
http://vbaexpress.com/forum/showthread.php?t=10358

[blastpwr1970]

Thank you Lucas
Not exactly what I am looking for do.
I still want to be able to use Combo Box, I think is more user friendly.
:beerchug:
</IMG>

[Bob Phillips]

Try this

[blastpwr1970]

Thank's xld,
I works great.

How about assigning different macros to each line on the list?
Is it possible?

:bow:
Thank's