Hide all the Worksheets except the one selected in Combobox

Hi Experts,

I've a excel workbook with 12 sheets naming as (January, February, March.. till December). I've a User form in another workbook, which has one Combobox with the Sheets names as the values.

My question here is, Can i hide all the available sheets except the one which was selected in the combobox.

Any help is really appreciated !!

Use :
Sub hide(nameOfWorkSheet as string)
Worksheets(nameOfWorkSheet).Visible = False
End Sub

you must add the code that reads the unselected content of the BOX. Pass the name to this proc.

OK

bart

Hi Bart,

I am sorry i could not get what exactly you are trying to say. Please check my question. I've asked to hide all the visibile sheets in a workbook, except the one which was selected in the combobox. where in the combobox has the values as the sheet names of the workbook.

Thanks for your time and code.

Could someone please help me out on this, Any help is really appreciated.

Try adding something like this to your code:

Please Login or Register  to view this content.

try this......