Forum Discussion

LaurieG123's avatar
LaurieG123
Copper Contributor
Jan 27, 2021

Finding a Hidden Workbook

Hi~ I accidentally hid an open workbook and now I'm unable to find it so I can make it visible again.  I know it's still out there and open because I'm getting the warning telling me so.  Will somebody please help me find my file?  I'm using Excel 2016 in a Windows environment.  Thanks!

1 Reply

  • JMB17's avatar
    JMB17
    Bronze Contributor

    LaurieG123 

     

    Have you tried View/Unhide?

     

     

     

    Otherwise, the window may be "off the screen". If you are familiar with vba (or you could also google for instructions to access vba, add a new module, and copy/paste a macro into a module, or post back here), then you could try this macro to get the workbook window back into the viewable area.

     

    Sub MoveWindow()
         
         '//  Change to your workbook name (including file extension)
         Const wkbkName As String = "Workbook Name.Ext"
         
         With Workbooks(wkbkName).Windows(1)
              .WindowState = xlNormal
              .left = Application.left
              .top = Application.top
              .WindowState = xlMaximized
         End With
    End Sub

Resources