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