Hide/Show Sheets with drop down menu

[Deepak Sharma]

Hello Everyone,

In this excel file, I have many sheets, few colored few un-colored, what I need is a drop-down list of every sheet & I should have multiple choice to show/hide sheets. More info is given in the file.

Please see attached file.

Please suggest how it would be possible to do.

Thanks & Regards,
Deepak Sharma

 

[AlanSidman]

Look at this link to get started. Try to write the code yourself. Post back with problems you encounter.

https://www.mrexcel.com/forum/excel...e-worksheets-color-tab-vba-script-needed.html

 

[Deepak Sharma]

Hi Thanks! Alan,
I read all these & accordingly to the conversation held between them, I wrote that code and assigned to a button but it's hiding all the uncolored sheets.

But I need multiple options to work accordingly.

Please suggest! Pls. find the attached sheet for ref.

Regards,
Deepak Sharma

 

[vletm]

Deepak Sharma
One sample with 'Randomly'-feature ...

 

[Deepak Sharma]

Hi Vletm, Thanks for your help, It seems you have done it, but actually it's not running on my PC. I downloaded the file but it's not working, might be some issue. I 'm using Excel 2010. So... Please suggest.

Thanks & Regards,
Deepak Sharma

 

[vletm]

Deepak Sharma ... hmm? ... it's not working ...

How did You noticed that it's not working?
Did You change anything in that file?
Are Macros Enabled?

 

[Deepak Sharma]

Yes, Macros are enabled, I am selecting options in dropdown list but there is no change in tabs, everything remains as it is.

Regards,

 

[vletm]

Is that 'dropdown' is in cell 'K4' in 'Main'-sheet?
and
are there Macros in 'Main'-sheet's code page?

 

[Deepak Sharma]

Yes vletm, I opened it on someone else's PC, there it's working fine.
It's really Amazing Work Done, I am seriously amazed how you did that. Awsome!!!! Seriously !!
Thank you so much !!!!!

 

[vletm]

... two questions ... hmm ...
and
now You have to buy or at least use someone else's PC.
I would be wise to know and to learn ... why?

 

[Deepak Sharma]

Hi vletm,
No actually he forwarded me that sheet over the mail, then now it's working fine. I don't what happened at that time. I didn't see this issue before ever. Anyways thanks for your help!

Regards,