Unhiding multiple sheets is a workbook

John Little

New Member
Joined
Feb 24, 2003
Messages
1
We have a workbook template we use that has 10 worksheets that need to be unhidden and hidden, depending on who views the sheet, is there an easy way to unhide multiple sheets within a workbook, instead of selecting each one through the menu options. :confused:
 

Some videos you may like

Excel Facts

Why are there 1,048,576 rows in Excel?
The Excel team increased the size of the grid in 2007. There are 2^20 rows and 2^14 columns for a total of 17 billion cells.

DominicB

Well-known Member
Joined
Oct 3, 2005
Messages
1,569
Good evening John Little

Not via the Excel interface, no. However there's no reason why you can't write / record a macro and have it attached to a button that will hide / unhide any given worksheets when clicked. Shout out if you want some help coding that.

Alternatively, you can download my add-in via the link below which has a utility that can hide / unhide one, some or all worksheets all at once.

HTH

DominicB
 

Watch MrExcel Video

Forum statistics

Threads
1,113,990
Messages
5,545,365
Members
410,679
Latest member
rolandbianco
Top