Setting a macro button for a Worksheets

  • Thread starter Thread starter banchee
  • Start date Start date
B

banchee

I need help!! I need to set a button for one of my programs to work for
the rest of the WorkSheets on that Workbook. Ex. I have a program set
for "Sheet1" and I want the same program to work on "Sheet2", when I
push the button on "Sheet1". Any suggestions? Please help.
 
banchee,

Are you going to have 2 buttons or just one?
If 2, will they both be on Sheet1?

Either way, i guess you will end up replacing the
hardcoded sheet names with a variable that gets it value
from the Worksheet.Name property of each sheet.
 
I am only having on button. Could you please go into a little more
detail with what you were saying. Thanks for your time.

Kyle
 
Back
Top