Macro Folder

J

JulieD

Hi Scott

macros can "live" in two places ... in a specific workbook (or template) -
and in this case are only available for use when the specific workbook is
open) - or in the personal macro workbook known as personal.xls - which is
a hidden file that is opened when you start excel and holds macros which can
be access by any open workbook - , if you want to locate the personal.xls on
your system just do a search for it.

Cheers
JulieD
 
S

Scottmk

I'm looking for my XL start folder (I think) which is where I stored m
Personal.xls workbook w/macros. It was backed up on my old cpu, but
need to know where to look for it. Thanks
 
F

Frrank Stone

hi,
macros are stored in the vb editor
tools>macros>vb editor or keys alt +f11
the macro will be listed at the left in the project window.
 
H

Hari

Hi,

I have Win 2000 and My Personal.xls is in

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

Regards,
Hari
India
 
T

Tom Ogilvy

Use Windows Start Menu => Search. (search all your local drives)

The xlstart is located indifferent places based on version of excel. In
xl2000 and later, there are multiple locations.
 
Top