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

  • Thread starter Thread starter FLAQUITO
  • Start date Start date
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.
 
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.
 
Back
Top