Macros in Excel XP

  • Thread starter Thread starter Phil Boffin
  • Start date Start date
P

Phil Boffin

Hi,

I have recently started using office xp and have some
macros stored in the personal.xls file. They used to open
automatically in '97 but now I have to open the file every
time I start Excel. The files are in xlstart folder so
what's different? Any ideas?

regards

Phil
 
Phil

In XP the xlStart folder moved from C:\Program Files\Microsoft Office to
C:\Application Data\Microsoft\Excel.

I suspect this is your problem. (It actually moved in XL2000 I think)
 
Phil,

Excel files on these directories automatically open when I start excel
(Using OS XP pro, office XP.)
C:\Documents and Settings\MyUserName\Application
Data\Microsoft\Excel\XLSTART.
C:\Program Files\Microsoft Office\Office10\XLStart

You can also assign an alternate start up folder. Tools|Options|General

Put personal.xls in the correct xlstart folder or to your alternate start up
folder and this might solve the problem.

Jon-jon
 
Back
Top