Not sure if this is what you are looking for, but if you look at my post
above, I believe it is similiar to what you want.

I have a macro button on the work sheet. The user clicks on it, the macro
creates a copy of the active worksheet and attaches it to the email.

As I stated above it's been working great on our Windows 2000 machines but
for some reason, it won't run on our new XP systems.

Tim

" wrote:

Also I can not use an add-in. Going to be used by 100's of people who
will not have the add-in.
On Sat, 21 Oct 2006 17:14:19 +0200, "Ron de Bruin"
wrote:

My Add-in have this option also

You can use SaveCopyAs to create a copy of your workbook
Opn this workbook with code and delete the sheets you want.
Then Save/Close/Mail/kill this workbook