This will hide the worksheet named NameOfWorksheet.

Instead of using xlSheetVisible just use xlSheetHidden: If you want to Hide a Worksheet in Excel using VBA you can modify the code above. Where NameOfWorksheet is obviously the name of the Worksheet you want to Unhide in Excel. Sheets('NameOfWorksheet').Visible = xlSheetVisible You can type the below in the Immediate window and hit Enter: To do this quickly simply us this Excel Keyboard shortcut ALT+ F11. To Unhide a single Worksheet in Excel using VBA we need to use open the Visual Basic Editor. Select the Worksheet you want to unhide and click Ok.Click the Unhide button in the opened tab.To unhide a Hidden Worksheet in Excel proceed as follows: Then I will show you a few tricks of how to unhide all Sheets in Excel using VBA. I will start by showing a way to manually unhide an Excel Worksheet using the Excel Unhide Window. If there are multiple workbooks open, you can open find the one you're looking for in the Switch Windows list from the View tab of the Ribbon.To unhide Sheets in Excel you need to right click on the Worksheet tab and select the Worksheet you want to unhide from the Unhide Window. If you're using an Excel version that is older than 2013 and neither of the first two methods didn't work, try to Maximize the window of the workbook. Windows may be arranged in a way that you cannot see the worksheets tab. The older versions of Excel open workbooks in 'inner windows' under a main application window. Locate the section Display options for this workbook (make sure that your workbook is selected in the dropdown).In the Ribbon, click File > Options to open the Excel Options window.To make the tab section visible, follow the steps: If the worksheets tab is hidden, you need to go to the Options window. See How to unhide sheets in Excel with VBA for doing this quickly using VBA.

If you come across with this scenario frequently for more than one worksheet, you can use a VBA macro to speed things up. If the unhide sheet is disabled, this means that there are no hidden worksheet within the workbook.

Then in the Unhide dialog box > click sheet you want to unhide.

Right click on any visible tab on the worksheet > click Unhide.

Otherwise, you need to unprotect the workbook to perform structural updates on the workbook. You can easily unhide sheets in Excel if the workbook is not protected. This feature comes in handy when you want to hide calculations or data to simplify your Excel model. If you lost a worksheet or cannot find the worksheet tabs section in your workbook, fear not! In this guide, we're going to show you how to unhide sheets and various methods to restore disappeared worksheet tabs.Įxcel allows hiding worksheets.

My sheets in excel disappeared