ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Setting up and Configuration of Excel (https://www.excelbanter.com/setting-up-configuration-excel/)
-   -   New Workbook Task Pane (https://www.excelbanter.com/setting-up-configuration-excel/132537-new-workbook-task-pane.html)

Angie_S

New Workbook Task Pane
 
I would like to click on the "New" workbook icon at the top of a spreadsheet
and have it automatically open up a new workbook. Instead, a side pane opens
up that says "New workbook" or from "Existing workbook". I don't want that
pane to come up, I just want it to start a new workbook. Thanks!

Dave Peterson

New Workbook Task Pane
 
That's the way it works for me.

I'd try this.
Tools|Customize (just to see that dialog box)
rightclick on the New workbook icon on the standard toolbar.
click reset

Dismiss the dialog and try it out.

Angie_S wrote:

I would like to click on the "New" workbook icon at the top of a spreadsheet
and have it automatically open up a new workbook. Instead, a side pane opens
up that says "New workbook" or from "Existing workbook". I don't want that
pane to come up, I just want it to start a new workbook. Thanks!


--

Dave Peterson

Gord Dibben

New Workbook Task Pane
 
Angie

You can hit the "New" icon button to open a new workbook without the task pane.

Or on FileNew there are two "New" items.

One has an ellipse New... which opens the task pane.

The other has no ellipse. This one will open a new workbook without the task
pane popping up.

Can be found at ToolsCustomizeCommandsFile. Drag it to the File menu.

Note: using this will open a new workbook based on your BOOK.xlt customized
workbook Template if you have one stored in your XLSTART folder.


Gord Dibben MS Excel MVP



On Tue, 27 Feb 2007 08:53:33 -0800, Angie_S
wrote:

I would like to click on the "New" workbook icon at the top of a spreadsheet
and have it automatically open up a new workbook. Instead, a side pane opens
up that says "New workbook" or from "Existing workbook". I don't want that
pane to come up, I just want it to start a new workbook. Thanks!




All times are GMT +1. The time now is 09:45 AM.

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