Excel related, but not formulas or visual basic

immyjimmy

Active Member
Joined
May 27, 2002
Messages
251
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

Well-known Member
Joined
Nov 2, 2010
Messages
548
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 :cool:) has some instructions (http://www.cpearson.com/excel/AppEvent.aspx).

hth
 
Last edited:

immyjimmy

Active Member
Joined
May 27, 2002
Messages
251
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
 

Fluff

MrExcel MVP, Moderator
Joined
Jun 12, 2014
Messages
33,909
Office Version
365
Platform
Windows
You're not by any chance hitting Alt+W+H are you?
 

immyjimmy

Active Member
Joined
May 27, 2002
Messages
251
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!
 

Forum statistics

Threads
1,086,008
Messages
5,387,208
Members
402,050
Latest member
k8vn

Some videos you may like

This Week's Hot Topics

Top