The easiest solution (IMO) would be to change your buttons from Forms buttons
(shapes) to Control Toolbox Buttons (actual buttons with properties and
methods). These buttons are easy to reference and have the all of the
properties you require. It will be a bit of work, but it should not be too
bad. The Code for these buttons will be embedded right in the sheet. You just
need to add one line of code for each button to call your macros...

--
HTH...

Jim Thomlinson


"AnExpertNovice" wrote:

On Excel worksheets I use the button shape from the Forms toolbar and assign
macros.

Properties exist such as Name and AlternativeText but I am unable to find a
way to change what the user sees from VBA. There is no text, caption,
label, etc. property.

Since it can be edited manually it must be changeable from code, although it
may require Windows API to accomplish it.

Any suggestions?