View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Bob Flanagan Bob Flanagan is offline
external usenet poster
 
Posts: 340
Default Office/Excel 2003 - Stop toolbars automatically opening

Most likely Microsoft changed the name of the toolbar. Select View,
Toolbars, and see what the name is. If it has not changed, then try setting
the Enabled property to false.

Bob Flanagan
Macro Systems
Delaware, U.S. 302-234-9857
http://www.add-ins.com
Productivity add-ins and downloadable books on VB macros for Excel

"Mal" wrote in message
...
I was having a problem in Office XP with links to other
spreadsheets. Every time I clicked a link and opened
another spreadsheet, the Web and Review toolbars would
open. I inserted the follwoing code in each Workbook and
it solved the problem:

Sub Workbook_Open()

' Hide the "Web" and "Reviewing" Toolbars/Commandbars

Application.CommandBars("Web").Visible = False
Application.CommandBars("Reviewing").Visible = False

End Sub

I have now upgraded to Office 2003 and the Web toolbar
still opens, even though the code is there. Any ideas?