Without seeing the code, my guess is that the macro recorder put
explicit file names in the code, e.g., Windows("Book1.xls").Activate.
You need to modify the code so that it will reference the
ActiveWorkbook instead of a specific named workbook.

Cordially,
Chip Pearson
Microsoft MVP 1998 - 2010
Pearson Software Consulting, LLC
www.cpearson.com
[email on web site]




On Wed, 13 Jan 2010 09:31:01 -0800, Chuck Sena <Chuck
wrote:

I created a workbook with many macros using the simple "record macro" tool.
This fiel was saved in *.XLS format. It is intended to be a master fille and
when you fill it out as a form you re-save it with a new name.

the problem I am running into is that after I re-save it wit a new name the
Macros won't work properly. I get an error message and when I click to run
the debugger the macro lists the original workbook name.

How do I fix this so that the macros work regardless of file name?