ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Opening Excel (https://www.excelbanter.com/excel-discussion-misc-queries/58560-opening-excel.html)

tx.turtle

Opening Excel
 
I accidentially overwrote the blank worksheet that automatically appears when
opening Excel. How do I reset this or even better how can I get no worksheet
to display when I open Excel?

Dave Peterson

Opening Excel
 
There's a workbook template named book.xlt that is located in your XLStart
folder.

You should be able to open it, edit it and save it the way you like.

If you really don't want to use it, just delete it.

To keep excel from creating that workbook when you open excel, you can create a
new shortcut to excel and use that. But you have to add a parameter telling
excel not to create that new worbook.

Create a new shortcut to excel.exe
But add /e (spacebar slash e) to the end of the target.

excel.exe /e
or
"C:\yourpathto\excel.exe" /e

If you look in xl's help for "Customize how Excel starts", you'll see more info.

tx.turtle wrote:

I accidentially overwrote the blank worksheet that automatically appears when
opening Excel. How do I reset this or even better how can I get no worksheet
to display when I open Excel?


--

Dave Peterson

David McRitchie

Opening Excel
 
There is also a sheet.xlt template which is used whten adding worksheets to
and *existing* worksheet or to your workbook in addition to the number of sheets
you originally requested.




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

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