I have written a VBA macro in an excel file. If a user
loads the excel file, and a renamed version of the same
file Excel uses the macro from the last file loaded. If
the last file loaded is closed first, and then the macro
is again used, Excel wants to load the second file again.

If I have been unclear, perhaps this step-by-step view
will help:

Load file 1:
Load file 2:
Run Macro A
Close file 2:
Run Macro A (it exists in file 1)
Excel wants to load file 2

Is there a way to associate the macro only to the
particular XLS workbook?

Thank you.
Dave Miller