Macro to unhide sheet based on sheet name

Hi,

I'm trying to look for a simple macro which will unhide sheets based on their sheet name but haven't had any luck. I've got several sheets which I would like to unhide when a command button is clicked. The sheet names are:
1. Guidance
2. Template
3. Schedule of Authority.

If these are unhidden when the workbook is open because the command button was clicked, I would like these to hide automatically when the workbook is closed so they are not showing when the workbook is opened again.

Any help would be greatly appreciated. Many thanks.

Create a button on the main sheet of your workbook. Attach this code to it.

Please Login or Register  to view this content.

In the Workbook Events, add this to the Before Close Event

Please Login or Register  to view this content.

My bad. Change the Trues to False in the BeforeClose Event. A senior moment in copying code from my workbook to the forum. Please accept my apologies.