Need VBA Code to Open Hidden sheet when click corresponded value in Cmbox1

Hi experts

i have create list box validation team wise, i want vba command to go to particular sheet for selection of sheet name

if i click IT in comboBox1 and click command , combo sheet should open, then when i back to sheet the opening sheet should hide back.

There is 2 sheet have abbreviation as sheet name becoz some team is look long,even team member not understand short abbreviations so i keep long string like Business Order Management in bombobox, but in sheet tab BOM

2.Vendor Logistic Team have abbreviation as VLT in sheet tab.


Help on this

Regards
JohnMN

Thanks boss for Code , its work, can u add line for when i back index sheet, already opened sheet has to back hide,

Thanks its works solved

Opps thats my ID too, Cross posting by autofill login unfortunately.Thanks for solved