How do I add a tooltip to an Excel toolbar button without coding?

[Simple]

I have created a button to run a macro. When you move the cursor over it, it
says "Custom Button" ... I want it to say "Print Report". How can I do this
within Excel without having to do any coding?

I am a complete novice when it comes to coding within Excel and have no
reason or desire to want to learn. I want to use the "built-in" features of
Excel to accomplish this.

Also, I would like to know whether I can MODIFY an existing custom button to
run a macro other than the one it was originally created for.

Thank you very much.

 

[Gord Dibben]

Assuming a Button on a ToolBar

Tools>Customize

Right-click on the button and change the name at "Name"

At the same time you can "Assign Macro" to change the macro assigned to the
button.


Gord Dibben MS Excel MVP