Databases Reference
In-Depth Information
•
Divider:
True if a “divider” should be placed before the menu item or submenu item.
•
Optional. A code number that represents the built -in graphic images that are
displayed next to an item. Follow
this link
for more information about determining
FaceID code numbers.
FaceID:
B.4
AN EXAMPLE MENU
The figure below shows the menu that is created using the table above.
B.5
USING THIS TECHNIQUE
To use this technique in your workbook or add-in, follow these general steps:
1.
Download menumakr.xls
. This file contains the VBA code, plus a worksheet name
MenuSheet.
2.
Copy all of the code in Module1 to a module in your project.
3.
Add subroutines like these to the code module for the ThisWorkbook object:
