One word of warning:
The *hidden* toolbars will still be hidden when the user opens a
different workbook. Most users like to have their *favorite* toolbars
visible by default and would be irritated to have to *rebuild* their
preferred set.
To remedy this, you should return to visibility all items you have
hidden. Do this in the Workbook_Close event.
You may also hide all toolbars with
Application.DisplayFullScreen=True
Then reverse this as you close the wbk (Workbook_Close event).
---
Message posted from
http://www.ExcelForum.com/