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


Keith wrote:

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?