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


--
Cordially,
Chip Pearson
Microsoft Most Valuable Professional
Excel Product Group
Pearson Software Consulting, LLC
www.cpearson.com
(email on web site)



"NJD" wrote in message
...
Is there a method of making a command butoon visible on all worksheets
without creating a new object on each sheet? I've put it in a userform,
but
then I cannot navigate between sheets without closing the form.