VBA for hide worksheet except active worksheet selected by Combobox

[Neilesh Kumar]

Dear Experts,

Please find here attached workbook, I am using the combobox to jump over the worksheets with the help of below code but the current code keeps visible the inactive worksheets as well:

Please Login or Register  to view this content.

I am currently seeking the VBA to jump over the selected worksheet with the help of combobox and only the active worksheet will be visible and rest other will be very hidden and when i do close the workbook the last selection from combobox will be clear and will be reset as blank.

Request to you please do help me. Your precious phase and valuable support would be appreciated.

Many thanks and kind regards,

Neilesh

Combobox Selection.xlsb

[LeoTaxi]

Try

Please Login or Register  to view this content.

Kind regards
Leo

[Neilesh Kumar]

Thank you so much Dear Expert LeoTaxi. Its worked like a charm. Dear Expert is it possible to clear the last selection of combobox before close so when i open the workbook i can start from the Home tab. Because currently after reopening the workbook it is directly taking to the last selected tab or can we set it by default to the home tab before closing the workbook.

Many thanks and kind regards,

Neilesh