View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Mal[_4_] Mal[_4_] is offline
external usenet poster
 
Posts: 2
Default Office/Excel 2003 - Stop toolbars automatically opening

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?