Finding a Hidden Workbook

%3CLINGO-SUB%20id%3D%22lingo-sub-2100553%22%20slang%3D%22en-US%22%3EFinding%20a%20Hidden%20Workbook%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2100553%22%20slang%3D%22en-US%22%3E%3CP%3EHi~%20I%20accidentally%20hid%20an%20open%20workbook%20and%20now%20I'm%20unable%20to%20find%20it%20so%20I%20can%20make%20it%20visible%20again.%26nbsp%3B%20I%20know%20it's%20still%20out%20there%20and%20open%20because%20I'm%20getting%20the%20warning%20telling%20me%20so.%26nbsp%3B%20Will%20somebody%20please%20help%20me%20find%20my%20file%3F%26nbsp%3B%20I'm%20using%20Excel%202016%20in%20a%20Windows%20environment.%26nbsp%3B%20Thanks!%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2100553%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2100630%22%20slang%3D%22en-US%22%3ERe%3A%20Finding%20a%20Hidden%20Workbook%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2100630%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F943999%22%20target%3D%22_blank%22%3E%40LaurieG123%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHave%20you%20tried%20View%2FUnhide%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22JMB17_0-1611720491223.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F249714i3ACAB58C512700AC%2Fimage-size%2Fmedium%3Fv%3D1.0%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22JMB17_0-1611720491223.png%22%20alt%3D%22JMB17_0-1611720491223.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EOtherwise%2C%20the%20window%20may%20be%20%22off%20the%20screen%22.%20If%20you%20are%20familiar%20with%20vba%20(or%20you%20could%20also%20google%20for%20instructions%20to%20access%20vba%2C%20add%20a%20new%20module%2C%20and%20copy%2Fpaste%20a%20macro%20into%20a%20module%2C%20or%20post%20back%20here)%2C%20then%20you%20could%20try%20this%20macro%20to%20get%20the%20workbook%20window%20back%20into%20the%20viewable%20area.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CPRE%20class%3D%22lia-code-sample%20language-applescript%22%3E%3CCODE%3ESub%20MoveWindow()%0A%20%20%20%20%20%0A%20%20%20%20%20'%2F%2F%20%20Change%20to%20your%20workbook%20name%20(including%20file%20extension)%0A%20%20%20%20%20Const%20wkbkName%20As%20String%20%3D%20%22Workbook%20Name.Ext%22%0A%20%20%20%20%20%0A%20%20%20%20%20With%20Workbooks(wkbkName).Windows(1)%0A%20%20%20%20%20%20%20%20%20%20.WindowState%20%3D%20xlNormal%0A%20%20%20%20%20%20%20%20%20%20.left%20%3D%20Application.left%0A%20%20%20%20%20%20%20%20%20%20.top%20%3D%20Application.top%0A%20%20%20%20%20%20%20%20%20%20.WindowState%20%3D%20xlMaximized%0A%20%20%20%20%20End%20With%0AEnd%20Sub%3C%2FCODE%3E%3C%2FPRE%3E%3C%2FLINGO-BODY%3E
Occasional Visitor

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

@LaurieG123 

 

Have you tried View/Unhide?

 

JMB17_0-1611720491223.png

 

 

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