LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
Max Max is offline
external usenet poster
 
Posts: 9,221
Default 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
---


 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel file opens but no worksheets visible SELIGMAN MAINE Excel Discussion (Misc queries) 3 July 5th 06 10:32 PM
Book.xlt opens at startup - not Book1 Mark McDonough Excel Discussion (Misc queries) 0 May 23rd 06 04:26 PM
Excel opens without a visible worksheet Raul Excel Programming 0 November 1st 04 03:32 PM
Word doc opens, but not in visible window? Ed[_9_] Excel Programming 2 October 31st 03 03:42 PM
UserDefined Function that opens another w/book Regan Excel Programming 1 September 1st 03 10:21 AM


All times are GMT +1. The time now is 11:35 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"