Book suddenly opens with no visible sheets

[Max]

Hi guys,

One file which used to open normally, suddenly opens today but with no
visible sheets, just a gray screen. urrgh... I can see everything's still
there in VBE (by opening a new book, and pressing Alt+F11 to get to VBE).
The file has a couple of regular module subs (a few simple recorded macros)
but it doesn't have any subs in the ThisWorkbook.

In a sense, its behaviour is just like PERSONAL.XLS where you can see its
Sheet1 in VBE (with property set to xlSheetVisible) but the sheet doesn't
show in Excel.

What can I try to get this file back to normal ?
(I'm able to open other files with subs normally)

Thanks

---

 

[Max]

Forgot to mention it's an Excel 97 file
(I'm using Excel 97)

---

 

[broro183]

hi Max,

When I want to unhide my personal.xls I go to _w_indow - _u_nhide. Does
this work for you?

hth
Rob Brockett
NZ
Always learning & the best way to learn is to experience...

 

[Tom Ogilvy]

If Window=>Unhide in Excel itself doesn't work (but hopefully that is it),
you can try

In the VBE, go to the project explorer and click on the ThisWorkbook entry
for this workbook. Look at the properties window (if it isn't visible, go
to View, and click on properties in the top menu). Look at the isaddin
setting. If it says True, change it to false.

this is just a guess based on what you said.

 

[Max]

Marvellous ! Thanks, Rob.

 

[Max]

Thanks for insights, Tom. Rob's suggestion "Window=>Unhide" worked for me.
I did check the IsAddin property as you had suggested, and it was set at:
FALSE
(Will bear this check in mind as a further possible route)

 

[broro183]

Hi Max,

No problem, thanks for the feedback.
& ditto from me - I'll keep Tom's stuff in mind too


Rob Brockett
NZ
Always learning & the best way to learn is to experience...