personal macro workbook

F

fgwiii

On my computer whenever I open Excel, a file called
Personal.xls is automatically loaded but is hidden. This
file appears to retain the macros I run. However, on one
of my colleague’s computer, she does not have a
personal.xls file. I sent her mine, saved it to her PC and
hid it as mine was hidden. But whenever she opens Excel,
the file is not there and has to me opened manually.

Is there a setting that needs to be set to get this to
open whenever Excel opens?

Thanks!

Fred
 
G

Gord Dibben

Personal.xls must be stored in the XLSTART folder.

XLSTART folder location differs with versions of Excel.

XL 2000, 2002 and 2003

C:\Documents and Settings\username\Application Data\Microsoft\Excel\XLSTART

XL97

C:\Program Files\Microsoft Office\Office\XLSTART

Gord Dibben Excel MVP
 

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