Apr 18 2021 08:43 PM
Apr 19 2021 12:51 AM
If you want to protect worksheets with confidential data from prying eyes or hide a sheet with intermediate calculations for a better overview, this is easy to do.
On the one hand by right-clicking on the sheet tab that you want to hide and then selecting "Hide" or on the other hand via tab: Start–> Group: Cells–> Command: Format–> Hide & Show–> Hide sheet.
Only when you have hidden at least one worksheet does the "Show ..." command appear in the tab menu. You can now select the sheets you want to show from a list.
Dialog box that appears when showing worksheets
You select the sheet that you want to show and click on "Ok". This is exactly how it works with the Show Sheet command. You can find it as follows: Tab: Home–> Group: Cells–> Command: Format–> Hide & Show–> Hide Sheet. Unfortunately, without programming in VBA, worksheets can only be shown individually.
With VBA, approach (not tested)
Enter the following in the VBA editor (ALT + F11) in the direct window (CTRL + G):
Code:
Activewindow.Top = 1
Confirm with [Enter] and the folder should be visible again.