Book suddenly opens with no visible sheets
 

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

Book suddenly opens with no visible sheets
 

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

Book suddenly opens with no visible sheets
 

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


--
broro183
------------------------------------------------------------------------
broro183's Profile: http://www.excelforum.com/member.php...o&userid=30068
View this thread: http://www.excelforum.com/showthread...hreadid=505258

Book suddenly opens with no visible sheets
 

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.

--
Regards,
Tom Ogilvy

"Max" wrote in message
...
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
---

Book suddenly opens with no visible sheets
 

Marvellous ! Thanks, Rob.
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"broro183" wrote in
message ...

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


--
broro183
------------------------------------------------------------------------
broro183's Profile:
http://www.excelforum.com/member.php...o&userid=30068
View this thread: http://www.excelforum.com/showthread...hreadid=505258

Book suddenly opens with no visible sheets
 

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
---
"Tom Ogilvy" wrote in message
...
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.

--
Regards,
Tom Ogilvy

Book suddenly opens with no visible sheets
 

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



--
broro183
------------------------------------------------------------------------
broro183's Profile: http://www.excelforum.com/member.php...o&userid=30068
View this thread: http://www.excelforum.com/showthread...hreadid=505258