Edit:

For example:

The macro in this workbook works ------ c:\test\test.excel
The copied macro in this workbook fails ------ c:\test\copy of
test.excel

Sorry, that should say:

For example:

The macro in this workbook works ------ c:\test\test.xls
The copied macro in this workbook fails ------ c:\test\copy of
test.xls

-----------------

I've been up for 36 hours. Time for sleep.

Joseph