1 / 13

Customizing Menus and Toolbars: A Comprehensive Guide to Command Bars

This guide provides detailed instructions on how to customize menus and toolbars effectively. Learn to manipulate command bars, including moving, resizing, and showing/hiding buttons. Discover how to remove unwanted elements like the "Type a question for help" box and change properties of built-in buttons. Additionally, it covers creating new toolbars and buttons, as well as attaching custom command bars to objects. Master the use of the CommandBars collection to enhance your application's functionality.

clyde
Télécharger la présentation

Customizing Menus and Toolbars: A Comprehensive Guide to Command Bars

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Customizing Menus and Toolbars

  2. Manipulating Command Bars • Customize: • Right-click any place on a command bar and cick Customize … • Customize window: • Toolbars, Commands, Options • Moving and resizing command bars • Showing and hiding command bars

  3. Showing and hiding toolbar buttons • Click (not right-click) the Toolbar Option button • Click Add or remove buttons

  4. How to remove “Type a question for help” box • With the Customize window open, • Right-click the box • Clear the checkbox next to the Show the Ask …

  5. Changing the Properties of Built-In Buttons • Open the Customizing window • Select the toolbar from the Toolbar list • Right-click the button in the toolbar and choose the property to change: • Name • Change button image • Properties window: • ScreenTip • OnAction • Macro • VBA function: =MsgBox(“Hello”)

  6. Restoring Toolbar Default • With Customizing window open: • Click Toolbars tab • Select the toolbar • Click Properties button • Click Restore Defaults button

  7. Creating New Toolbar • With Customizing window open: • Click Toolbars tab • Click the New button • Enter a name • Adding buttons to the new toolbar • Click Commands tab • Select Categories • Select commands • Drag the command to the new toolbar

  8. Creating New Button • With the Customizing window open: • Click Commands tab • Click File in the Categories box • Click the Custom button • Drag the Custom button to the toolbar • Right-click the new Custom button in the toolbar to change properties: • Name • Default style • Text only • Assign hyperlink • Properties • Screen tip • OnAction

  9. Creating Menu and Submenu • With the Customizing window open: • Click Commands tab • Click New Menu in the Categories box • Drag the New Menu to the toolbar • Right-click the new menu to assign a new name for the menu • Select and drag buttons to the new menu • Submenu • Same procedure

  10. Attaching a Customer Command Bar to an Object • Forms, reports and Commands have properties to attach a custom toolbar or menu bar.

  11. The CommandBars Collection • Application • CommandBars • This collection contains: • Menu bars • Toolbars • Shortcut menus • Custom command bars

  12. Access Built-in command bars • 1 menu bar named “Menu Bar” • 51 tool bars • 126 shortcut menus

  13. To Retrieve a Commandbar from the Collection • CommandBars(“commandbar name”) • Commandbar properties: • Object browser • Example: • Private Sub Command0_Click() • CommandBars("menu bar").Enabled = True • End Sub • Private Sub Command1_Click() • CommandBars("menu bar").Enabled = False • End Sub

More Related