Hide and Restore Toolbars in Excel
Attach a custom toolbar to your spreadsheet that doesn't get in the way of the end user's settings for other spreadsheets when yours is closed.
One of the most exciting parts of Excel is the customizability of its output to end users. For example, you might build your own custom toolbar to distribute it with your spreadsheets. However, the golden rule of when/if to change any part of Excel is to make sure everything for the user goes back to how it was when the user closes your specific spreadsheet-in other words, restore the user's settings!
There are many ways to do this, some of which are extremely complicated (often unnecessarily). This tutorial provides a cleaner, less complicated way.
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:
Open the workbook that should display the custom toolbar.
Right-click on any gray, unused part of any toolbar and select Customize.
On the Toolbars page, check MyToolbar (or the applicable name), to make it visible.
Select Attach, drag your tool toolbar from the Attach Toolbar dialog, and press Copy.
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.