Excel 2000
I've got a workbook with 4 worksheets, I have a macro which is setup to copy
two of the worksheets and email them to a different department. I also have
another macro which combines some of the cells so the address is in one line
to make it easier for the other department. The problem I have is when the
first macro is activated, it copies all of the data, as it should, but leaves
the macro information behind, so when the other department try to run their
"quicker magic address button" it doesn't work.

Is there a way to have a macro which will work for all workbooks? Or is
there away that I can get the macros to go over at the same time as the
information on the worksheets?

Thanks in advance.