Forum Discussion

Brgray's avatar
Brgray
Copper Contributor
Apr 18, 2021

Two workbooks need one hidden

I have two workbooks open but I need one hidden but running in background still while having the other workbook still on screen. Can someone help explain how to if you even can.
excel

1 Reply

  • NikolinoDE's avatar
    NikolinoDE
    Platinum Contributor
    Apr 19, 2021

    Brgray 

    Hiding and showing worksheets

    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.