Sheet Window Unhide

When you unhide a worksheet you can only do so one at a time so select from the list of hidden sheets in the unhide dialog box.

Sheet window unhide. Hold down the alt f11 keys in excel and it opens the microsoft visual basic for applications window. Unhide worksheets using the ribbon. Alternatively you can alt f11 to open vba window select each sheet in turn in teh project window and double click the visible field in the properties window. One of the first tricks an excel user learns is to hide and unhide a sheet.

In the unhide pop up window select the worksheet to unhide and click ok. This is an exceptionally useful feature as it allows us to store data in a sheet such as lists and tables but keep the user of the workbook from seeing manipulating and more importantly corrupting the information on the hidden sheet. So how do we unhide all the worksheets once. Unhide all hidden worksheets by vba code the following short vba code also can help you display all of the hidden sheets at the same time.

Select one or more worksheet tabs at the bottom of the excel file. If unhide is unavailable the workbook does not contain hidden workbook windows. As with hiding worksheets excel has no keyboard shortcut for unhiding a sheet but you can still use the ribbon. Or you can right click on any visible tab and select unhide.

Unhide window can only unhide single sheets at a time but imagine you have to unhide 10 sheets then repeating the same set of tasks for 10 times is frustrating. Sub unhide sheets containing dim ws as worksheet for each ws in activeworkbook worksheets if instr ws name pivot 0 then. We can unhide all the sheets by writing the vba code in excel below is the code to unhide all the hidden worksheets in the workbook. To unhide a worksheet you just do the opposite.

I unhide all sheets in one shot.