personal macro workbook

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