How to change default workbook when starting Excel?

[Guest]

How can I change the default workbook, when I open Excel, from book1.xls to
personal.xls

 

[Guest]

Have a look at here:

http://www.dicks-blog.com/archives/2004/04/14/ready-set-startup/

 

[Ron de Bruin]

Hi Ner

If you want a change the default workbook then you must use a template.

Open a new workbook and change the things you want in this workbook (Font/background color, font and font size and ?)
Then use File>Save As to save the file as a Template (xlt, in 2007 xltx or xltm) with the
name "Book" in the XLSTART folder.
Every workbook you insert is based on this template.

You can find the Excel startup folder here
Note: this a hidden folder

C:\Documents and Settings\Ron\Application Data\Microsoft\Excel\XLSTART

Or in Vista
C:\Users\Ron\AppData\Roaming\Microsoft\Excel\XLSTART

With code you can find the correct path with this code line
MsgBox Application.StartupPath

 

[Dave Peterson]

Just to add to Ron's reply...

Most people use personal.xls as a home for the macros that they always want
available when excel starts. Most wouldn't want this used as a basis for any
new workbook.

In fact, this personal.xls is usually hidden from the user.

 

[potro809]

I successfully created book.xlt and sheet.xlt, and it's so nice to be
able to set my own colors. However, I just realized that when I open
a *.csv file (created by another application) with Excel, the color
palette that is used is the MS default. Does anyone know a way around
this?
Thanks!
Andrew