View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
gocush[_27_] gocush[_27_] is offline
external usenet poster
 
Posts: 1
Default How to make the Toolbar Invisible through VBA

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/