I'm was having trouble with an imported module, then I gave up on it. Now I'm having trouble with using VBA code to assign a module to a button on a newly copied sheet, while it and the original sheet are both open (unavoidable).

The main issue, is that after the new sheet is attached to an email, sent and opened on the other end, the button tries to access the original sheet.

I don't understand why it would do this, because the button code should be assigned to the open sheet (newly copied) while it's open, and the 'active' worksheet. I'm likely wrong though. I'm sure there's a way to make this work. 

Please Login or Register  to view this content.