![]() ![]() A macro to unhide all hidden sheets in an Excel workbook by Susan Harkins in Microsoft Office, in Microsoft on August 8, 2011, 12:08 AM PST Unhiding Excel sheets is easy, but can be tedious. ![]() To unhide column A, right-click the column B header or label and pick Unhide Columns. If you right-click a sheet tab and select “ Unhide ”, the proceeding dialog box only allows a single sheet to be selected for the unhide operation. If you don’t see the first column (column A) or row (row 1) in your worksheet, it might be hidden. Sub Unhide_SD_Sheet() ThisWorkbook.Unprotect "Password" If Sheet2.Visible Then Sheet2.Visible = xlSheetHidden Else: Sheet2.Visible = xlSheetVisible If Sheet2.Visible Then MsgBox ("Supporting Documentation Sheet Now Visible") Else MsgBox ("Supporting Documentation Sheet Now Hidden") ThisWorkbook.Protect "Password" End Sub Aspose.Cells lets you work without Microsoft Excel installed. To unhide row 1, right-click the row 2 header or label and pick Unhide Rows. However, if you have a workbook with multiple hidden sheets there is no easy way to unhide all of the sheets. Alternatively only unhide the rows or columns on the selected or current sheet.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |