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?

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?

or by typing

?Application.StartupPath

in the VBIDE immediate window

--
---
HTH

Bob

(change the xxxx to gmail if mailing direct)


"RichardSchollar" wrote in message
ps.com...
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?

or he may have created an add-in (ToolsAddins)

--
---
HTH

Bob

(change the xxxx to gmail if mailing direct)


"RichardSchollar" wrote in message
ps.com...
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?

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

Richard


Bob Phillips wrote:

or he may have created an add-in (ToolsAddins)

--
---
HTH

Bob

(change the xxxx to gmail if mailing direct)


"RichardSchollar" wrote in message
ps.com...
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?