ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   New Users to Excel (https://www.excelbanter.com/new-users-excel/)
-   -   How do I add a tooltip to an Excel toolbar button without coding? (https://www.excelbanter.com/new-users-excel/197340-how-do-i-add-tooltip-excel-toolbar-button-without-coding.html)

Simple

How do I add a tooltip to an Excel toolbar button without coding?
 
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

How do I add a tooltip to an Excel toolbar button without coding?
 
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.




All times are GMT +1. The time now is 01:14 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com