ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Small spreadsheet opens with no toolbars? (https://www.excelbanter.com/excel-discussion-misc-queries/210885-small-spreadsheet-opens-no-toolbars.html)

Stockwell43

Small spreadsheet opens with no toolbars?
 
Hello,

A coworker of mine opened a spreadsheet. She then clicked on a tab to open
another spreadsheet but that spreadsheet opened in a smaller window and does
not allow her to do anything and she can't close it unless she closes the
main spreadsheet. What did she do? When it is opened, there are no toolbars,
file menu, edit menu and so on and none of them will open when this smaller
spreadsheet is up.

How does she fix it??

Thanks!!!

Abbey

Small spreadsheet opens with no toolbars?
 


"Stockwell43" wrote:

Hello,

A coworker of mine opened a spreadsheet. She then clicked on a tab to open
another spreadsheet but that spreadsheet opened in a smaller window and does
not allow her to do anything and she can't close it unless she closes the
main spreadsheet. What did she do? When it is opened, there are no toolbars,
file menu, edit menu and so on and none of them will open when this smaller
spreadsheet is up.

How does she fix it??

Thanks!!!



That must be the little devil. lol. Anyway, she should try this - re-open
the spread sheet, and in stead of using the insert new worksheet command, she
should simply copy the existing worksheet (i.e. duplicate it) and clean it up
for use.

Also she should double check on the options (toolsOptionsView) and
ensure all 4 top check boxes are checked.

wish you luck

Stockwell43

Small spreadsheet opens with no toolbars?
 
Hi Abbey,

I let her know to give it try.

Thank you for responding!!!

"Abbey" wrote:



"Stockwell43" wrote:

Hello,

A coworker of mine opened a spreadsheet. She then clicked on a tab to open
another spreadsheet but that spreadsheet opened in a smaller window and does
not allow her to do anything and she can't close it unless she closes the
main spreadsheet. What did she do? When it is opened, there are no toolbars,
file menu, edit menu and so on and none of them will open when this smaller
spreadsheet is up.

How does she fix it??

Thanks!!!



That must be the little devil. lol. Anyway, she should try this - re-open
the spread sheet, and in stead of using the insert new worksheet command, she
should simply copy the existing worksheet (i.e. duplicate it) and clean it up
for use.

Also she should double check on the options (toolsOptionsView) and
ensure all 4 top check boxes are checked.

wish you luck



All times are GMT +1. The time now is 04:32 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com