Page 230 - Excel Progamming Weekend Crash Course

k540629 ch16.qxd 9/2/03 9:34 AM Page 205

Session 16 — Creating Custom Toolbars 205

REVIEW
This session showed you how to create custom toolbars and distribute them with your Excel
application.
You can add as many custom toolbars as needed to Excel.
A custom toolbar can contain Excel’s predefined buttons as well as custom buttons.
To distribute a custom toolbar with a worksheet, you must first attach it to the
worksheet.
You use the CommandBars collection to access individual toolbars in VBA code.
You can display or hide and change the position of toolbars in your VBA code.

QUIZ YOURSELF

1. When working in Excel, how do you display and hide toolbars? (See the
“Displaying and Hiding Toolbars” section.)
2. How many different toolbars can a particular button be on? (See the “Adding and
Removing Toolbar Buttons” section.)
3. What steps are required to distribute a custom toolbar with a workbook? (See the
“Distributing Toolbars” section.)
4. In VBA code, how do you change the position of a toolbar? (See the “Hiding and
Displaying Toolbars in VBA Code” section.)