I have a workbook that contains VB macros(Excel). I want to copy certain
sheets from this workbook to another workbook and share it with others.
However, when I do this and send it to them, the macro refers back to my
original workbook.

Example: a simple button(macro assigned to it) is used to navigate to
certain sections of the worksheet works fine in original. But when I copy
it to a new book, it tries to "link" back(find) to the original(even though
I have copied the corresponding macro module to the new workbook). Is there
an easy way to just tell it to look for the module with the same name
"locally"?

Sorry if this is an easy one; I just can't find answer in the "help".

Thanks, Bob