Excel related, but not formulas or visual basic

[immyjimmy]

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

 

[Dr. Demento]

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.

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

 

[immyjimmy]

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

 

[Dr. Demento]

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

 

[Fluff]

You're not by any chance hitting Alt+W+H are you?

 

[immyjimmy]

You're not by any chance hitting Alt+W+H are you?

I do a lot of Alt+Tab and CTRL+C, X & V, but no closer to H than that, and no triple combinations.
It's weird to be closing a blank session of Excel and be asked if I want to save the hidden workbook!