New Workbook Defaults to Personal.xls

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
 
D

Dave Peterson

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.
 

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