Thanks Thanks:  0
Likes Likes:  0
Results 1 to 2 of 2

Thread: Excel related, but not formulas or visual basic

  1. #1
    Board Regular immyjimmy's Avatar
    Join Date
    May 2002
    Location
    Oregon
    Posts
    249
    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
    531
    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.

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
  •