Book suddenly opens with no visible sheets

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Max - 26 Jan 2006 10:17 GMT

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
Singapore
http://savefile.com/projects/236895
xdemechanik
---

Reply to this Message

Max - 26 Jan 2006 10:27 GMT

Forgot to mention it's an Excel 97 file
(I'm using Excel 97)
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---

Reply to this Message

broro183 - 26 Jan 2006 11:00 GMT

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...

Signature

broro183

Reply to this Message

Max - 26 Jan 2006 16:08 GMT

Marvellous ! Thanks, Rob.
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---

> hi Max,
>
[quoted text clipped - 11 lines]
> broro183's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=30068
> View this thread: http://www.excelforum.com/showthread.php?threadid=505258

Reply to this Message

Tom Ogilvy - 26 Jan 2006 12:27 GMT

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.

Signature

Regards,
Tom Ogilvy

> Hi guys,
>
[quoted text clipped - 18 lines]
> xdemechanik
> ---

Reply to this Message

Max - 26 Jan 2006 16:15 GMT

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)
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---

> If Window=>Unhide in Excel itself doesn't work (but hopefully that is it),
> you can try
[quoted text clipped - 9 lines]
> Regards,
> Tom Ogilvy

Reply to this Message

broro183 - 27 Jan 2006 04:12 GMT

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...

Max Wrote:

> Thanks for insights, Tom. Rob's suggestion "Window=>Unhide" worked for
> me.
[quoted text clipped - 8 lines]
> xdemechanik
> ---

Signature

broro183

Reply to this Message