New Workbook Defaults to Personal.xls

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Henry Stockbridge - 24 Jul 2006 16:13 GMT

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

Reply to this Message

Dave Peterson - 24 Jul 2006 17:25 GMT

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.

> Hi,
>
[quoted text clipped - 7 lines]
>
> Henry

Signature

Dave Peterson

Reply to this Message

Henry Stockbridge - 24 Jul 2006 17:45 GMT

Dave,

Thanks for the tip. Now I'm set.

Henry

======================

> It sounds like your personal.xls workbook is visible (most people have this
> workbook opened as a hidden workbook).
[quoted text clipped - 20 lines]
> >
> > Henry

Reply to this Message

Rate this thread: