» Change the availability for the shortcut menus using VBA in Microsoft Excel
VBA macro tip contributed by Erlandsen Data Consulting offering Microsoft Excel Application development, template customization, support and training solutions
CATEGORY - Menus, Toolbars, Status bar in VBA
VERSION - All Microsoft Excel Versions
The macro below shows how you can toggle the availability state for the shortcut menus.
Sub ToggleCommandBars()
Dim cbEnabled As Boolean
cbEnabled = Not CommandBars(25).Enabled
CommandBars(25).Enabled = cbEnabled ' shortcutmenu for cells
CommandBars(26).Enabled = cbEnabled ' shortcutmenu for columns
CommandBars(27).Enabled = cbEnabled ' shortcutmenu for rows
CommandBars("Toolbar List").Enabled = cbEnabled ' shortcutmenu for toolbars
End Sub
Book Store:
Recommended Books:
- Microsoft Excel 2002 Visual Basic for Applications Step by Step
- Business Analysis with Microsoft Excel (2nd Edition)
- Understanding Financial Statements
- The McGraw-Hill 36-Hour Course in Finance for Nonfinancial Managers
- Infectious Greed: How Deceit and Risk Corrupted the Financial Markets
- Real Estate Loopholes: Secrets of Successful Real Estate Investing
No comments have been submitted.
