Macro for Hide all worksheets except active one and unhide all the worksheets

Dear Experts,

I am looking for the macro to Hide all worksheets non-active worksheets and unhide worksheets except those which was hidden manually in case of protected workbook and protected worksheets.

Regards,

Neilesh

This project creates an INDEX on the first sheet. Each Sheet Name is a hyperlink to that sheet.

All others sheets remain hidden until the hyperlink is clicked for the specific sheet. Each sheet has a hyperlink
back to the INDEX sheet. When that hyperlink is clicked, the sheet auto hides.

Please Login or Register  to view this content.

Each sheet must also have this macro which causes the sheet to auto hide when transitioning back to the INDEX sheet. NOTE that each
sheet's macro will be different in that the sheet name must reference that sheet's unique name (shown in RED).

Please Login or Register  to view this content.