Microsoft provides programming examples for illustration only, without warranty either expressed or implied. This includes, but is not limited to, the implied warranties of merchantability or fitness for a particular purpose. This article assumes that you are familiar with the programming language that is being demonstrated and with the tools that are used to create and to debug procedures. Microsoft support engineers can help explain the functionality of a particular procedure, but they will not modify these examples to provide added functionality or construct procedures to meet your specific requirements.
Create the Macro
If you do not have a macro, you can use the following sample Visual Basic for Applications macro that displays the text "This is a test" in a dialog box when the macro is run.
Sub HelloWorld()
MsgBox "This is a test"
End Sub
Create a New Toolbar
You can create a new toolbar to contain all of your custom macros. To do this, follow these steps:
1. | On the Tools menu, click Customize, and click the Toolbars tab. |
2. | Click New. |
3. | In the Toolbar name box, type MyMacros, and click OK. |
4. | To the right of the Customize dialog box, a small empty box appears. This is the new toolbar that you created in step 3. |
Create the Button for the Macro
1. | In the Customize dialog box, click the Commands tab. |
2. | In the Categories list, click Macros. |
3. | In the Commands list, drag the custom button (identified by a smiley face icon) to the MyMacros toolbar that you created in step 3 of "Create a New Toolbar". |
4. | Right-click the new custom button, and click Assign Macro. |
5. | Click the HelloWorld macro that you created in the "Create the Macro" section of this article, and click OK. |
6. | In the Customize dialog box, click Close. |
NOTE: You can dock and undock the
MyMacros toolbar as you can any other Standard toolbar.