Hello Excel experts,
I have a spreadsheet that has 11 tabs named Main, Sheet1, Sheet2, Sheet3 and so on until Sheet10. The names of all sheets are saved on the sheet named main which has a drop down containing these names. All the sheets named Sheet1.....Sheet10 are hidden.
What I want to achieve is When i select the sheet name from the drop down (the one which I want to unhide) and then press an Activex command button the corresponding sheet should be unhidden.
I have attached the sample spreadsheet for your kind consideration. Can someone kindly help.
I have a spreadsheet that has 11 tabs named Main, Sheet1, Sheet2, Sheet3 and so on until Sheet10. The names of all sheets are saved on the sheet named main which has a drop down containing these names. All the sheets named Sheet1.....Sheet10 are hidden.
What I want to achieve is When i select the sheet name from the drop down (the one which I want to unhide) and then press an Activex command button the corresponding sheet should be unhidden.
I have attached the sample spreadsheet for your kind consideration. Can someone kindly help.