#1   Report Post  
gcotterl
 
Posts: n/a
Default "File" "New"

When I click "File" then "New", a box containing several icons appears. How
can I get an empty workbook to open when I click "New" (instead of having to
select the "Workbook" icon)?

  #2   Report Post  
Dave Peterson
 
Posts: n/a
Default

Add another New to your File menu.

Tools|customize|commands tab|File category

Notice that there's two different File commands:

File...
and
File

The File... (with the ellipses) is the one that's already there.
drag the File (without the ellipses) to the File menu.



gcotterl wrote:

When I click "File" then "New", a box containing several icons appears. How
can I get an empty workbook to open when I click "New" (instead of having to
select the "Workbook" icon)?


--

Dave Peterson
  #3   Report Post  
gcotterl
 
Posts: n/a
Default

You're "too good"!

Thanks,

gary



"Dave Peterson" wrote:

Add another New to your File menu.

Tools|customize|commands tab|File category

Notice that there's two different File commands:

File...
and
File

The File... (with the ellipses) is the one that's already there.
drag the File (without the ellipses) to the File menu.



gcotterl wrote:

When I click "File" then "New", a box containing several icons appears. How
can I get an empty workbook to open when I click "New" (instead of having to
select the "Workbook" icon)?


--

Dave Peterson

  #4   Report Post  
Bob Phillips
 
Posts: n/a
Default

Use the New icon on the toolbar.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"gcotterl" wrote in message
...
When I click "File" then "New", a box containing several icons appears.

How
can I get an empty workbook to open when I click "New" (instead of having

to
select the "Workbook" icon)?



  #5   Report Post  
Gord Dibben
 
Posts: n/a
Default

gary

You must have realized that Dave was talking about New and New...

Not File and File...


Gord Dibben Excel MVP

On Mon, 18 Apr 2005 12:51:05 -0700, "gcotterl"
wrote:

You're "too good"!

Thanks,

gary



"Dave Peterson" wrote:

Add another New to your File menu.

Tools|customize|commands tab|File category

Notice that there's two different File commands:

File...
and
File

The File... (with the ellipses) is the one that's already there.
drag the File (without the ellipses) to the File menu.



gcotterl wrote:

When I click "File" then "New", a box containing several icons appears. How
can I get an empty workbook to open when I click "New" (instead of having to
select the "Workbook" icon)?


--

Dave Peterson




  #6   Report Post  
Dave Peterson
 
Posts: n/a
Default

uh, oopsie!

The operation was a success--but the patient died. (Everything was ok except
for the real details. Doh!)

Thanks, Gord.

Gord Dibben wrote:

gary

You must have realized that Dave was talking about New and New...

Not File and File...

Gord Dibben Excel MVP

On Mon, 18 Apr 2005 12:51:05 -0700, "gcotterl"
wrote:

You're "too good"!

Thanks,

gary



"Dave Peterson" wrote:

Add another New to your File menu.

Tools|customize|commands tab|File category

Notice that there's two different File commands:

File...
and
File

The File... (with the ellipses) is the one that's already there.
drag the File (without the ellipses) to the File menu.



gcotterl wrote:

When I click "File" then "New", a box containing several icons appears. How
can I get an empty workbook to open when I click "New" (instead of having to
select the "Workbook" icon)?

--

Dave Peterson


--

Dave Peterson
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Opening a file with code without a set file name jenkinspat Excel Discussion (Misc queries) 1 March 4th 05 10:50 AM
Locating a file in excel with a partial file name. Audra Excel Discussion (Misc queries) 1 February 19th 05 08:51 PM
Locating a file in excel with a partial file name. Audra Excel Discussion (Misc queries) 0 February 19th 05 02:03 PM
Locating a file in excel with a partial file name. Audra Excel Discussion (Misc queries) 0 February 19th 05 02:03 PM
Read Text File into Excel Using VBA Willie T Excel Discussion (Misc queries) 13 January 8th 05 12:37 AM


All times are GMT +1. The time now is 03:04 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"