How to change default workbook when starting Excel?


G

Guest

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

Advertisements

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

Advertisements

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top