I am working with Excel 2000.

I have a worksheet that has several pictures on it. Each picture has an
associated macro. The macros are in an extenal workbook. Currently each
picture, when it tries to access the macro, it cannot find the file, because
the file containing the macros has been moved. I have a number of files
that are setup this way and need a macro that will go in and automatically
remove the folder/path refference from the file/macro reference.

Example:
Currently referenced macro:
F:\Dir1\SubDir2\SubSubDir3\OperatorMacros.xls!Pict ure6_Click

I want it to read:
OperatorMacros.xls!Picture6_Click

I have 6 pictures on the worksheet and each picture has the same problem.

Also, can I set something such that it doesn't ever try to reference a path
for the file. I already have the workbook set up to make sure the file that
has the macros in it is loaded.

Please help, and thank you in advance.

Eric Pearce