Reassign it to the first workbook after you do the save as.

--
Regards,
Tom Ogilvy

"Fran99" wrote in message
...
I have created a macro that i use in more that one workbook, but with
minor
changes.

I am assigning the macro to a pulldown menu.

When i assign it in one workbook everything is fine.

Then i assign it in the next workbook it changes to macro in the first
workbook to
the second Workbook.