New Workbook Defaults to Personal.xls

  • Thread starter Thread starter Henry Stockbridge
  • Start date Start date
H

Henry Stockbridge

Hi,

Whenever I start a new instance of Microsoft Excel, the default
filename is Personal.xls, instead of Book1 (or whatever...)

Since I have some procedures built into my Personal Macro Workbook, can
I change the default name of a new Excel workbook?

Any help you can lend would be appreciated.

Henry
 
It sounds like your personal.xls workbook is visible (most people have this
workbook opened as a hidden workbook).

Open excel
with personal.xls the active workbook
window|hide
and close excel

You'll be prompted to save personal.xls (because of that change to hidden).
Select yes.

Now close excel and reopen it to test it out.
 
Dave,

Thanks for the tip. Now I'm set.

Henry

======================
 
You must log in or register to reply here.

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

Similar Threads

Personal.xls doesn't open when starting with existing workbook 1
Problem with Personal.XLS and macros added to my toolbar 3
Copy range to multiple workbooks 2
personal.xls 3
How to change default workbook when starting Excel? 4
Problem with Personal.xls 4
Create employee attendance db using personal.xls? 3
Macro for all Excel Workbooks to print to PDF 2

Back
Top