how do i get excel to stop opening a blank worksheet @ startup?

L

lady_gemini1971

i've checked the options and customize and cant find a way to get it to stop
doing this. it's really just annoying.
 
R

Ron Coderre

I'm curious....
Excel without a workbook?

Do you have a particular workbook you'd like to open upon Excel startup
instead of a blank workbook?

If Yes, Excel will open all files in the XLSTART folder. Mine is located in
this kind of location:
C:\Documents and Settings\CoderreR\Application Data\Microsoft\Excel\XLSTART

OR

You can select an alternate startup folder.
From the Excel main menu:<tools><options><general tab>
Enter a path in the "At startup, open all file in" section.

(Alternatively, [Ctrl]+[F4] will close the active workbook)

Does any of that help?
***********
Regards,
Ron

XL2002, WinXP
 
D

dolivastro

You have to create an icon, or a menu item, that calls Excel.exe with
the "/e" switch. That is, create an icon, for the target, enter
"[path]Excel.exe /e". Of course, [path] needs to be filled in with
folder that contains your program.

Hope this helps,
Dom
 
G

Gord Dibben

Dom

The closing double-quote must come before the <space>/e

"[path]Excel.exe" /e


Gord Dibben MS Excel MVP


You have to create an icon, or a menu item, that calls Excel.exe with
the "/e" switch. That is, create an icon, for the target, enter
"[path]Excel.exe /e". Of course, [path] needs to be filled in with
folder that contains your program.

Hope this helps,
Dom



lady_gemini1971 said:
i've checked the options and customize and cant find a way to get it to stop
doing this. it's really just annoying.
 
D

dolivastro

I wasn't actually including either quote. I was just using the quotes
to delimit the text that was entered in the properties box. But you're
right. The quotes, as you have written it, will never hurt and are
actually needed if the path contains a blank. Thanks for pointing that
out.

Dom



Gord said:
Dom

The closing double-quote must come before the <space>/e

"[path]Excel.exe" /e


Gord Dibben MS Excel MVP


You have to create an icon, or a menu item, that calls Excel.exe with
the "/e" switch. That is, create an icon, for the target, enter
"[path]Excel.exe /e". Of course, [path] needs to be filled in with
folder that contains your program.

Hope this helps,
Dom



lady_gemini1971 said:
i've checked the options and customize and cant find a way to get it to stop
doing this. it's really just annoying.
 
G

Gord Dibben

OK

I thought the double quotes were for real<g>

Gord

I wasn't actually including either quote. I was just using the quotes
to delimit the text that was entered in the properties box. But you're
right. The quotes, as you have written it, will never hurt and are
actually needed if the path contains a blank. Thanks for pointing that
out.

Dom



Gord said:
Dom

The closing double-quote must come before the <space>/e

"[path]Excel.exe" /e


Gord Dibben MS Excel MVP


You have to create an icon, or a menu item, that calls Excel.exe with
the "/e" switch. That is, create an icon, for the target, enter
"[path]Excel.exe /e". Of course, [path] needs to be filled in with
folder that contains your program.

Hope this helps,
Dom



lady_gemini1971 wrote:
i've checked the options and customize and cant find a way to get it to stop
doing this. it's really just annoying.

Gord Dibben MS Excel MVP
 
Top