Hi, if you want to assign the macro to a button, just pull up the Forms
toolbar, select the button you want, draw it on the screen, click on the
button, and a dialogue box appears asking you which macro you want to assign
it to. Choose the appropriate macro, close the dialogue box, get out of
design mode, click the button, and watch your macro run.

"Ryk" wrote:


Unsure what that is doing, it gives me a paste option and i can
manually chose where to put it and it works, but I think I need a
button tied to a macro or something, this part of excel new to me. Let
me explain a bit, I have 3 spreadsheets full of values and formulas, if
possible with even a macro or three, can i have sheet one, copy to a
preset workbook's sheet one by clicking a "month one" button, then
reset my spreadsheet, and when finished editting, hit a "month two"
button and have that sent to sheet2 of preset workbook etc? I'll have
alot of people working with this program and i need to make it very
easy too use for them. But end all be all, 3 different sheets, sent to
a new workbook, with values only is end goal.

Thanks for your reply as well Dave, I have posted 3 times, and this is
first reply I have recieved...

Ryk