Personal.xls folder

T

T.R.

I created a macro in my personal.xls for use whenever I
start Excel. However, my personal folder no longer opens
when I start Excel.

In order to use the macro I have to go to the C drive and
open personal.xls.

I tried to change the startup by going to tools, option
and general, but that does not seem to work either.

Any suggestions?

Thanks.

- T.R.
 
K

Ken Wright

Personal.xls is a hidden file that is stored in the XLSTART folder, and will
normally be launched automatically when you run Excel. You will not see it, but
any macros in it will normally be accessible from the Tools / Macro / Macros
option as long as you have it set to 'Macros in All Open Workbooks'
 
C

Christeena

I had the exact opposite problem. I didn't want my macro
to start every time I opened Excel.

Is it saved in your XLSTART folder? If not, it needs to
be there. (I had to take mine out) You should find it
under "Application Data", "Microsoft", "Excel",
then "XLSTART".

Hope it helps
 
K

Ken Wright

A macro won't run automatically unless you tie it to an auto_open event or
something similar. Just being in personal.xls or any other workbook that is
automatically launched when Excel starts will not run any macros. It simply
allows you to be able to run them if you so choose by using Tools / Macro /
Macros and they will be available.
 
Top