Setting a macro button for a Worksheets
 

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.



------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~ View and post usenet messages directly from http://www.ExcelForum.com/

Setting a macro button for a Worksheets
 

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.

-----Original Message-----
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.



------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~ View and post usenet messages directly from
http://www.ExcelForum.com/

.

Setting a macro button for a Worksheets
 

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



------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~ View and post usenet messages directly from http://www.ExcelForum.com/