A tiny trick:

Rather than copy sheets from Book A to Book B, make a "Book B" by making a
copy of Book A, removing material you don't want in B, adding material you do
want in B and then calling the modifed copy Book B.

The point is that by copying Book A, you will also copy all the included
macros.
--
Gary''s Student - gsnu200907


"Hansplay" wrote:

When I copy a set of worksheets from one workbook to another the macros don't
follow.

Let me Explain:

I copy worksheets from workbook A into workbook B and close workbook A.
Then from workbook B I select the command button to run a macro. What
happens is workbook A opens again and runs the macro. If I break the link
with workbook A in workbook B using Edit/Links the command button doesn't do
anything.

How can I move the worksheets into the new workbook and have them behave as
they did originally?

Thanks