Hide/Unhide sheets based on combo box selection

[prabs_message]

Hi all,

I'm not used to VBA and am having a bit difficulty putting together code for a combobox selection that hides and unhides sheets based on its selection. Eg. A combobox that has a dropdown list of 2, 3, 4, & 5. Sheets 2-5 are hidden by default (before selecting value in the combobox). Upon selecting "2", it should unhide sheet 2. If I select "3" it should unhide sheet 3 but hide sheets 2, 4, & 5 and so on.. sheet 1 is to stay unhidden at all times.

I hope I have explained it clearly and would greatly appreciate your assistance

[jraj1106]

Hi.

Check this out:

hideunhidesheets.xlsm