ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   how do i get excel to stop opening a blank worksheet @ startup? (https://www.excelbanter.com/excel-discussion-misc-queries/114773-how-do-i-get-excel-stop-opening-blank-worksheet-%40-startup.html)

lady_gemini1971

how do i get excel to stop opening a blank worksheet @ startup?
 
i've checked the options and customize and cant find a way to get it to stop
doing this. it's really just annoying.

Ron Coderre

how do i get excel to stop opening a blank worksheet @ startup?
 
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


"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.


[email protected]

how do i get excel to stop opening a blank worksheet @ startup?
 
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

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

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

"[path]Excel.exe" /e


Gord Dibben MS Excel MVP


On 17 Oct 2006 10:58:09 -0700, "
wrote:

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.



[email protected]

how do i get excel to stop opening a blank worksheet @ startup?
 
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 Dibben wrote:
Dom

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

"[path]Excel.exe" /e


Gord Dibben MS Excel MVP


On 17 Oct 2006 10:58:09 -0700, "
wrote:

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

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

I thought the double quotes were for real<g

Gord

On 18 Oct 2006 06:37:10 -0700, "
wrote:

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 Dibben wrote:
Dom

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

"[path]Excel.exe" /e


Gord Dibben MS Excel MVP


On 17 Oct 2006 10:58:09 -0700, "
wrote:

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


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

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