Assuming a Button on a ToolBar

ToolsCustomize

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

On Sat, 2 Aug 2008 08:36:01 -0700, Simple
wrote:

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.