G
Guest
How can I change the default workbook, when I open Excel, from book1.xls to
personal.xls
personal.xls
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
G
Guest
R
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
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
D
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.
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.
P
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
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