Macro Folder

[Scottmk]

Could someone tell me where that folder is that holds all macros?
Thanks

 

[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

 

[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

 

[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.

 

[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

 

[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.