ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Open Excel with no workbook (https://www.excelbanter.com/excel-programming/368087-open-excel-no-workbook.html)

Jac Tremblay[_4_]

Open Excel with no workbook
 
Hi,
Is it possible to set some option so that when Excel is opened from the
Start menu, there is no new workbook displayed.
I think it is not but I just want to have someone confirm that point.
Thanks
--
Jac Tremblay

Leith Ross[_687_]

Open Excel with no workbook
 

Hello Jac,

Yes you can. Here is how to modify the Start Menu shortcut to open
Excel without a new workbook...

How to Add a Switch to the Microsoft Excel Shortcut
To add a switch to the Microsoft Excel shortcut:
1. Right-click Start, click Open, and then double-click the Programs
folder.
2. Right-click the shortcut for Microsoft Excel, click Properties, and
then click the Shortcut tab.
3. In the Target box, type the switches that you want after the command
that runs Excel.exe. For example, if you want Excel to start without
creating a new workbook, and the Excel.exe file is installed in the
default location, type the following in the Target box:
"C:\Program Files\Microsoft Office\Office\Excel.exe" /e
4. Click OK.

Note If the options on the Shortcut tab in the Properties dialog box
are not available, your shortcuts are Windows Installer shortcuts. For
more information about how to modify these shortcuts, click the
following article number to view the article in the Microsoft Knowledge
Base:
290379 (http://support.microsoft.com/kb/290379/) Office Shortcut tab is
unavailable

Sincerely,
Leith Ross


--
Leith Ross
------------------------------------------------------------------------
Leith Ross's Profile: http://www.excelforum.com/member.php...o&userid=18465
View this thread: http://www.excelforum.com/showthread...hreadid=564170


Jac Tremblay[_4_]

Open Excel with no workbook
 
Hi Leith,
You are quite right. It can be done and it is not complicated. The only
problem here is that we are not administrators and the programs setup does
not allow us to do some changes in the shortcuts in the Start menu folder.
The Execute command: "Excel.exe /e" will do the job.
Thank you very much for this quick and useful answer.
--
Jac Tremblay


"Leith Ross" wrote:


Hello Jac,

Yes you can. Here is how to modify the Start Menu shortcut to open
Excel without a new workbook...

How to Add a Switch to the Microsoft Excel Shortcut
To add a switch to the Microsoft Excel shortcut:
1. Right-click Start, click Open, and then double-click the Programs
folder.
2. Right-click the shortcut for Microsoft Excel, click Properties, and
then click the Shortcut tab.
3. In the Target box, type the switches that you want after the command
that runs Excel.exe. For example, if you want Excel to start without
creating a new workbook, and the Excel.exe file is installed in the
default location, type the following in the Target box:
"C:\Program Files\Microsoft Office\Office\Excel.exe" /e
4. Click OK.

Note If the options on the Shortcut tab in the Properties dialog box
are not available, your shortcuts are Windows Installer shortcuts. For
more information about how to modify these shortcuts, click the
following article number to view the article in the Microsoft Knowledge
Base:
290379 (http://support.microsoft.com/kb/290379/) Office Shortcut tab is
unavailable

Sincerely,
Leith Ross


--
Leith Ross
------------------------------------------------------------------------
Leith Ross's Profile: http://www.excelforum.com/member.php...o&userid=18465
View this thread: http://www.excelforum.com/showthread...hreadid=564170




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

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