hi

I have two macros that work when pressing a button. I want to make the macros work for a specific sheet so that i can press the button on one sheet and it will effect another sheet.

for example one button activates my rightfax application but i want it to only fax a specific sheet

my other button emails a sheet which i want it to attach a specific sheet to the outlook email

what do i need to change or add to make this happen?