Now we can write our VBA code or sub-procedure in this module: Right-click on the workbook name in the ‘Project-VBAProject’ pane and then click on ‘Insert’-> ‘Module’ as follows : On doing this, a window opens as follows: Go to the Developer tab, then click on Visual Basic Editor, or press Alt+F11 to open the Visual Basic Editor window. We write the VBA code in the Visual Basic Editor that can be accessed as follows: So one way to unhide all the hidden sheets in one go is by writing a VBA code in Excel. But this might be quite a time taking if there are many sheets that are required to be unhidden. Using the ‘Unhide’ dialog box, we could only unhide one sheet at a time. In the above three examples, we have seen that we could not unhide all the sheets at once. Now we wish to unhide all the hidden worksheets in one go. So this is how the workbook looks like now: Now, in the workbook that we have seen in the above three examples, we again hide all the three sheets (Sheet1, Sheet2, Sheet3) in them. So in the above screenshot, we can see that ‘Sheet3’ is now visible to us that was previously hidden. This will display the selected hidden sheet. Now select the sheet that is to be unhidden and then click on ‘OK’. On using this Excel shortcut key, the Unhide dialogue box (same as we saw in the above two examples) will appear with all the hidden worksheets. Example #3Īpart from the above two ways that we have used to unhide one sheet at a time, there is another method to open the same ‘Unhide’ dialog box and then unhide the required hidden sheet. Now we can repeat the above steps to unhide ‘Sheet3’ as well.
So in the above screenshot, we can see that ‘Sheet2’ is now visible to us that was previously hidden. Now select the sheet that is to be unhidden and then click on ‘OK.’ This will display the selected hidden sheet. The following screenshot illustrates this. On doing this, an Unhide dialog box will appear with all the hidden worksheets. Right-click on any of the worksheet tabs and then select ‘Unhide.’ Now, we wish to unhide ‘Sheet2’ and ‘Sheet3’ in the same Excel workbook. So in the above screenshot, we can see that ‘Sheet1’ is now visible to us that was previously hidden. We can repeat the above steps if we wish to unhide the other two sheets.
0 kommentar(er)
