A Macro That Unhide and Going a Specific Sheet

[Unexpc]

Hi guys
There is a macro that Unhide multiple sheet and Going to specific one of them and then, when deselect one of them (select another sheet from this sheets) again hidden...

 

[maabadi]

No. it only need to do at your one sheet ( start Sheet). and if you do correct, it worked correctly.
It always maintain visible start sheet and the sheet shows at combobox.

 

[maabadi]

I uploaded my file with 14 sheet with comboBox.
On Developer Tab go to Design Mode and Right click on ComboBox and go to Properties and do same for your comboBox
1. Change your combobox name to cmbsheet at Properties window
2. If you want Change font to what you want
Then Back Excel window and again Right click on ComboBox and go to View code
1. Select cmbsheet from first dropdown
2. Select change from second dropdown
3. copy from my sheet to your sheet
Back to Excel & deactivate design mode then
1. go to VBA window
2. Select first sheet (Sheet with ComboBox) and Right click on it and go to View code
3. copy code from my sheet to yours
4. save file as .xlsm and close your file
5. Reopen your file. you should see your sheet names at combobox

Macro Hiding Sheet with ComboBox