In a workbook, you might have some sheets that everyone uses, and other sheets that only one or two people need to use, for Admin functions.

For example, the workbook shown below has a data entry sheet for orders, and two Admin sheets -- one for lists and one for workbook options.

To make it obvious which sheets are for Admin functions, I used an "Admin_" prefix for those sheets.

Hide the Admin Sheets

To prevent accidental changes to the Admin sheets, and to keep the workbook simpler to use, the Admin sheets can be hidden.

You can right-click on each Admin sheet tab, and click Hide, to manually hide each sheet. Or, to make the job easier, you can use a macro to hide the sheets, and another macro to show them.

To run a macro: Click the View tab on the Ribbon, then click Macros. Click

Continue reading Hide Specific Excel Sheets With Macro