In a nutshell, a For Each loop cycles through all the sheets in the Worksheets collection and sets each sheet’s Visible property to true. Here’s a quick macro that you can copy into almost any workbook to quickly unhide sheets: Then, select the sheet you want to unhide from the list and click OK. Although easy, unhiding sheets in this manner is tedious if there happens to be several of them.ĭoing this several times to unhide all hidden sheets isn’t necessary. To unhide sheets, click any sheet tab and choose Unhide from the context menu. When you need to update or fix a workbook for a user, you have to remember the hidden sheets and then unhide them – which is easy enough, unless you removed that functionality from the workbook! We hide sheets for many reasons, but mostly, to keep other people out of them. Use this simple macro to unhide all hidden sheets in an Excel workbook. Unhiding Excel sheets is easy, but can be tedious. A macro to unhide all hidden sheets in an Excel workbook
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |