Button refers to macro in the wrong workbook

Ok.

I would create a sheet specific macro for this.

So when you mail the individual sheet the macro goes with it.

I have created a sample and attached it.

I have made it run when you click on the tab to select sheet 2.

to view and edit the code, open visual basic, select view project explorer.

Now right click on sheet two and select view code.

Enjoy.