Move the macro to an addin and build a toolbar to execute the code.

Keep only the code in the template that is required in the file that should be
sent.

For additions to the worksheet menu bar, I really like the way John Walkenbach
does it in his menumaker workbook:
http://j-walk.com/ss/excel/tips/tip53.htm

Here's how I do it when I want a toolbar:
http://www.contextures.com/xlToolbar02.html
(from Debra Dalgleish's site)

Paul wrote:

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.

--

Dave Peterson