I've considered that, but there is one additional issue; the last
macro sends the workbook  using SendMail as an attachment to our ER
group which then reviews it and uploads it to the accounting system.

By copying to another workbook, we then have to return to the manual
send workbook as an attachment and add other data to the email that
I had automatically generated in the submect line.

The other idea that came up while discussing with a friend at work
was to create some code attached to a button on the ER groups
toolbar that would, when activated, check the open workbook for
macros and remove  them. This would be the ultimate solution as we
also have several hundred employers who send us salary data via
electronic of workbooks. We could get rid of all macro  code form
internal or external sources.