MS-Excel / General Formatting

Attaching Your Toolbar to the Workbook

Let's assume you have created a custom toolbar called MyToolbar and, for some purpose, want to hide all of Excel's built-in toolbars from the user, displaying only MyToolbar.

Before starting, it is vital that you attach your custom toolbar to the workbook that will be using it. This will also stop users from being able to make changes stick and will ensure an error-free process.

Here's how to attach a custom toolbar that takes care of these requirements:

  1. Open the workbook that should display the custom toolbar.
  2. Right-click on any gray, unused part of any toolbar and select Customize.
  3. On the Toolbars page, check MyToolbar (or the applicable name), to make it visible.
  4. Select Attach, drag your tool toolbar from the Attach Toolbar dialog, and press Copy.
  5. Press OK, then Cancel, and you're done!

You should nowbe aware that any changes made to your custom toolbar will not stick (between closing and reopening the workbook it's attached to, unless you first (before any changes) go back to the Attach Toolbar dialog, select your toolbar, this time from the right side (Toolbars in workbook), and press Delete. Then, make any changes needed and followSteps 1 through 5 again.

[Contents] [Next]

In this tutorial:

  1. Hide and Restore Toolbars in Excel
  2. Attaching Your Toolbar to the Workbook
  3. Coding the Toolbar Show and Restore