Why not create the same object on each sheet??:

Sub Macro2()
For Each sh In Worksheets
   sh.Activate
   ActiveSheet.Buttons.Add(248.25, 75.75, 90.75, 51).Select
   Selection.OnAction = "hello"
   Range("A1").Select
Next
End Sub

The usual way is to put the button on a toolbar.

hi
if you have to close the form to navigate sheet, your from is modal, meaning
that the form has focus untll closed. you need to make the form modaless. how.
you probable have a sub that shows the form, maybe something like this.
Sub mac1ShoCal()
Load frmCalendar
frmCalendar.Show
end sub

modal = t and is default
modalless = false
to make the form modaless place a zero(false) after the show command as in
the above example.....

frmCalendar.Show 0

look up the showmodal property in vb help.

Regards
FSt1

You can't have the same button on more than one sheet. You could put it on a
UserForm and show the form modelessly. Then, the form will be visible but
you can navigate between sheets. The form will just float there, waiting to
be clicked.

UserForm1.Show vbModeless '<< must include vbModeless to the Show method