PERSONAL.XLS.... How I can make this file not the default file???

F

FLAQUITO

I wrote some macros, since I did it, every time excel is opened appears this
PERSONAL.XLS file, even when open a new books appears as default, normally
BOOK1 should appears.
 
D

Dave Peterson

Did you mean to store those macros in personal.xls?

This is a common technique and a common filename that is used to store macros
that should be available whenever excel is opened.

But most people have that personal.xls file open as a hidden workbook.

In xl2003, you can:
open excel
With personal.xls the active workbook
Window|Hide
Then close excel.

You'll be prompted to save personal.xls (since it changed to be hidden). Answer
yes.

Then restart excel. You'll still have access to the macros in personal.xls, but
since that workbook is hidden, it won't be in the way.
 

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