Macros location

[Guest]

We had a member of staff who used Excel to fix formatting in a new file.
Since the files he ran the macro on were all new files the macro must reside
somewhere else.

How can I locate his macro?

 

[RichardSchollar]

Keith

Quite possibly these macros resided in his Personal Macro Workbook
(Personal.xls) which is normally located in the XLSTART folder on his C
drive (workbooks in this folder open automatically when Excel opens,
thus the macros contained within are available to use straightaway).

XLSTART is located (from Help):

You can find XLStart folders in C:\Documents and
Settings\username\Application Data\Microsoft\Excel or in C:\Program
Files\Microsoft Office\Office10

Richard

 

[Bob Phillips]

or by typing

?Application.StartupPath

in the VBIDE immediate window

--
---
HTH

Bob

(change the xxxx to gmail if mailing direct)

 

[Bob Phillips]

or he may have created an add-in (Tools>Addins)

--
---
HTH

Bob

(change the xxxx to gmail if mailing direct)

 

[RichardSchollar]

Or he may have used another workbook containing the macros located in
his alternative start-up location (Tools>Options>General tab "At start
up, open all files in").

Richard