Customizing "blank workbook"

N

NN

I have created "book.xlt", placed it i xlstartup fodler.
When i open excel, the workbook that opens as default, contains fthe
formatting from book.xlt.
However;
if I choose "File" --> "New..." (notice ...) and click on "Blank Workbook",
the workbook excel shows me, does not contain the desired formatting.
Is this how it is supposed to work?
Or am I doing something wrong?
Of course i would like "Balnk woorkbook" also to contain my default
formatting.
 
D

Dave Peterson

You can add New (w/o the dots) to the File dropdown and use that book.xlt. (You
could remove the New... option if you really hate it!)

Or you can click on the new icon on the standard toolbar to use book.xlt.
 
D

Dave Peterson

Ps.

To add New

Tools|Customize|commands tab|file category
drag the New icon over the file menu.
When the file menu expands, put it where you like it.

To delete New...
tools|customize (just to see that dialog)
expand the file menu and drag it off that toolbar.
 
N

NN

Thanks :blush:)

Dave Peterson said:
Ps.

To add New

Tools|Customize|commands tab|file category
drag the New icon over the file menu.
When the file menu expands, put it where you like it.

To delete New...
tools|customize (just to see that dialog)
expand the file menu and drag it off that toolbar.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top