Certain workbooks open invisible. The worksheet properties indicate that the wb should be visible. The only way I have found to make the wb visible is to use the arrange function under Window on the Menu Toolbar. Several workbooks open this way regardless of how they are saved.
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Excel 2000 non-visisble workbooks
- Thread starter sanluinc
- Start date
A window is the way you see the workbook. One workbook can have more than one window (>new window), each with its specific settings. One of window features is that it can be hidden. Window(s) properties are saved with workbook.
So, unhide the window and save the workbook.
combo
So, unhide the window and save the workbook.
combo
- Thread starter
- #3
The WBs are all opened in the same window. They are not hidden and, as I said before, their worksheet properties do not indicate that they are invisible. I have researched this problem extensively on the web... apparently I am the only person that has or has ever had this problem. Very frustrating.
BTW I'm using Excel 2000.
BTW I'm using Excel 2000.
Probably maximising will solve the problem too.
It seems that someone moved the window (normal view) outside excel desktop area.
The solution could be:
- maximise,
- create new workbook's window,
- close first workbook's window.
or
CTRL+F7 to activate window's movement,
or
if you use vba, with the code:
combo
It seems that someone moved the window (normal view) outside excel desktop area.
The solution could be:
- maximise,
- create new workbook's window,
- close first workbook's window.
or
CTRL+F7 to activate window's movement,
or
if you use vba, with the code:
Code:
ThisWorkbook.Windows(1).Left = 0
ThisWorkbook.Windows(1).Top = 0combo
- Status
