Results 1 to 5 of 5

Thread: Excel related, but not formulas or visual basic

  1. #1
    Board Regular immyjimmy's Avatar
    Join Date
    May 2002
    Location
    Oregon
    Posts
    250
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Unhappy Excel related, but not formulas or visual basic

    Hello...

    My work computer was recently upgraded and Excel now is hiding workbooks that I have open.
    I'm not hiding them, but until I found out about how to find hidden files, thought I was losing them.
    When I Googled "excel hides my workbook and I can't get it to stop", I found all sorts of help in how to hide and superhide sheets, but nothing on how to stop Excel from hiding workbooks.

    Does anyone have any ideas on why this might be happening and better yet, how to stop it?

    Thanks in advance,
    Jim

  2. #2
    Board Regular Dr. Demento's Avatar
    Join Date
    Nov 2010
    Location
    Skipping stones off Charon's Ferry
    Posts
    545
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Excel related, but not formulas or visual basic

    Not sure why it's doing it, but if you put the following code in your PERSONAL.XLSB file, it will loop thru all open workbooks and make them visible when Excel opens.

    Code:
    Private Sub Workbook_Open()
    
    Dim wb As Workbook
    
    For Each wb In Application.Workbooks
      If wb.Name <> "PERSONAL.xlsb" Then _
          Windows(wb.Name).Visible = True
    Next wb
    
    End Sub
    ** Edit **
    Actually, that will only solve half your problem; what you need is for this Sub to run anytime any new workbook is opened, not just when Excel is first started. The font of all Excel wisdom (Chip Pearson ) has some instructions (http://www.cpearson.com/excel/AppEvent.aspx).

    hth
    Last edited by Dr. Demento; May 16th, 2019 at 11:42 PM.

  3. #3
    Board Regular immyjimmy's Avatar
    Join Date
    May 2002
    Location
    Oregon
    Posts
    250
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Excel related, but not formulas or visual basic

    Thanks, Dr.

    What I'm doing is opening an Excel file, and all is well. I open another one (or two), and eventually, toggling back and forth between them, one will go into hiding.
    I can always select "VIEW" and "Unhide", but I haven't actively hidden any of them.
    I've checked to see if any VBA could be active, but these are files without macros.

    Thanks,
    Immy

  4. #4
    Board Regular Dr. Demento's Avatar
    Join Date
    Nov 2010
    Location
    Skipping stones off Charon's Ferry
    Posts
    545
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Excel related, but not formulas or visual basic

    That is strange!! I'm afraid you've just outstripped my usefulness!!!

  5. #5
    MrExcel MVP
    Moderator
    Fluff's Avatar
    Join Date
    Jun 2014
    Location
    Chippenham
    Posts
    28,298
    Post Thanks / Like
    Mentioned
    471 Post(s)
    Tagged
    47 Thread(s)

    Default Re: Excel related, but not formulas or visual basic

    You're not by any chance hitting Alt+W+H are you?
    - Posting Data try one of these tools
    - Posting guidelines, forum rules and terms of use
    - Read the FAQs

    Running Office 365 on Win 10

Some videos you may like

User Tag List

Tags for this Thread

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •