Home / MS-Excel / General Formatting

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.