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