Hiding workbooks

enny · Apr 18th, 2002, 09:33 AM

I'm running Windows NT with Excel 97. Each time I open numerous workbooks, Excel keeps hiding the previously opened ones.

Any suggestions?

Mark O'Brien · Apr 18th, 2002, 11:34 AM

Not quite sure what you're saying here.

Do you want to be able to see more than one book at a time? If so, you'll see two sets of buttons in the top right corner of your screen each has Minimise, Maximise and Close.

TO see more than one open workbook at a time click on the Maximise button on the lower set of buttons. This switches from full screen view to partial view.

If your problem is that you want to move between these workbooks, click on "Window" on your toolbar and at the bottom of the menu you will see all of the names of the open workbooks. Simply click on the name of the workbook you want to see.

enny · Apr 18th, 2002, 12:57 PM

The problem is occurring under Window menu. For example, if 5 workbooks are open, Excel will hide 2 of them and only 3 will show up in the list. To display the remaining 2, I have to click the unhide button. It will do this automatically.

Does this help?

Mark O'Brien · Apr 18th, 2002, 01:00 PM

Are there any macros present in these workbooks that woulb cause them to hide upon startup?

enny · Apr 18th, 2002, 01:06 PM

It's actually for a client of mine. I'll have to check with him. He mentioned that it usually does not happen right away. It will occur after he has worked on them for a while. He thought they were hidding due to the large size of the file. Have you ever heard of this occuring?

enny · Apr 18th, 2002, 02:19 PM

Just talked to client, there are no macros to hide sheets.

Apr 18th, 2002, 11:34 AM	#2
Mark O'Brien MrExcel MVP Join Date: Feb 2002 Location: Columbus, OH, USA Posts: 3,519	Not quite sure what you're saying here. Do you want to be able to see more than one book at a time? If so, you'll see two sets of buttons in the top right corner of your screen each has Minimise, Maximise and Close. TO see more than one open workbook at a time click on the Maximise button on the lower set of buttons. This switches from full screen view to partial view. If your problem is that you want to move between these workbooks, click on "Window" on your toolbar and at the bottom of the menu you will see all of the names of the open workbooks. Simply click on the name of the workbook you want to see. __________________ Mark O'Brien Columbus Ohio Celtic Supporters Club

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Apr 18th, 2002, 09:33 AM	#1
enny New Member Join Date: Apr 2002 Posts: 5	I'm running Windows NT with Excel 97. Each time I open numerous workbooks, Excel keeps hiding the previously opened ones. Any suggestions?

Apr 18th, 2002, 12:57 PM	#3
enny New Member Join Date: Apr 2002 Posts: 5	The problem is occurring under Window menu. For example, if 5 workbooks are open, Excel will hide 2 of them and only 3 will show up in the list. To display the remaining 2, I have to click the unhide button. It will do this automatically. Does this help?

Apr 18th, 2002, 01:00 PM	#4
Mark O'Brien MrExcel MVP Join Date: Feb 2002 Location: Columbus, OH, USA Posts: 3,519	Are there any macros present in these workbooks that woulb cause them to hide upon startup?

Apr 18th, 2002, 01:06 PM	#5
enny New Member Join Date: Apr 2002 Posts: 5	It's actually for a client of mine. I'll have to check with him. He mentioned that it usually does not happen right away. It will occur after he has worked on them for a while. He thought they were hidding due to the large size of the file. Have you ever heard of this occuring?

Apr 18th, 2002, 02:19 PM	#6
enny New Member Join Date: Apr 2002 Posts: 5	Just talked to client, there are no macros to hide sheets.