Hi Harold,

Are you working with Access or Excel?

As you posted in the Access Forum I will assume you meant Form, not Sheet.

What you want to do can be accomplished with an Event Handler Function

I only recall that if its a macro.  If you are using VBA your best bet is copy n paste. but make sure you keep the button name the same.

Yes, I am using access.      I have a button on the top of a page that says "Print report". I would like to have a button on the bottom that says the same thing but when I tried to copy the button and past it on the bottom of the FORM it does not work unless I basically redo the button.  I was trying to eliminate the extra step since I also wanted to copyh the button to multiple pages.

Copying and pasting a button (or any control) does not copy and paste its underlying code.  To able to truly "reuse" code somewhere else, one way is put said control on a separate form, then use it as a subform on other forms.  See pics below as an example.  My "color theme" form is dragged onto another form so its code can be used for that form.  Obviously, your code needs to be written in a way that would work with multiple forms or any form.  For instance, use the "Parent" object to refer to the parent form.

Good idea. How about setting the code as a public function?

Making the VBA public in such a case may not be useful, since all the procedures are likely event-driven, and they need to be run according to how that form's events play out.  At least that's how forms should be designed.  A form's code should be dictated by that form's events (hence, private procedures suffice), not from something else somewhere else out of the blue.

Actually I was trying to copy the button from the top of the page to the bottom of the page so that the user can click on either button and get the same result.

the buttons would need different names, IE BtnOne BtnTwo. just copy the vba code or on btntwo call BtnOne. the best way create a public function and on any button on many/any form call the function.