Hi Mike

Use a button from the control toolbox.
This button have a click event that is in the sheet module.

Copy your code in this event

If you need more help post back




--
Regards Ron de Bruin
http://www.rondebruin.nl



"UKNewbie" wrote in message ...
Hi,

I was wondering if it was possible to maintain the functionality of macros
when sending one sheet of a workbook via e-mail without the need for it to
link back to the original workbook.

Basically, I have buttons on each worksheet which perform various tasks.
That functionality would need to be maintained after sending each sheet to
it's relevant department.

I've tried moving the macro from a module into the worksheet and it saves
into the sent copy just fine. However, once it is received by the enduser, it
attempts to open with links back to the original workbook to allow the macros
to work. The enduser is not neccesarily going to have access to the original
workbook.

Any help, as always, will be most appreciated...

TIA

Mike

I think I get you.

Because I'm using drawing objects for interaction, it's causing the problem.
If I use command buttons and their associated subs, this will alleviate it..!?

If I'm off the track, let me know - I think I'll figure that out once I've
tried it, anyway ;o).

Otherwise, thanks for the help and taking time to respond.

Take care,

Mike

"Ron de Bruin" wrote:

Hi Mike

Use a button from the control toolbox.
This button have a click event that is in the sheet module.

Copy your code in this event

If you need more help post back




--
Regards Ron de Bruin
http://www.rondebruin.nl



"UKNewbie" wrote in message ...
Hi,

I was wondering if it was possible to maintain the functionality of macros
when sending one sheet of a workbook via e-mail without the need for it to
link back to the original workbook.

Basically, I have buttons on each worksheet which perform various tasks.
That functionality would need to be maintained after sending each sheet to
it's relevant department.

I've tried moving the macro from a module into the worksheet and it saves
into the sent copy just fine. However, once it is received by the enduser, it
attempts to open with links back to the original workbook to allow the macros
to work. The enduser is not neccesarily going to have access to the original
workbook.

Any help, as always, will be most appreciated...

TIA

Mike