Office/Excel 2003 - Stop toolbars automatically opening

M

Mal

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?
 
B

Bob Flanagan

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
 
M

Mal

Thanks Bob.

The name's were still the same, but setting the Enabled
property to False, rather than the Visible property to
False, worked in 2003.

I wish it was not a default, ot was a default that you
could turn off. I don't want to program every spreadsheet
I create. Even worse is that it does a similar thing in
Word and I don't want to go there.

Thanks.
Mal
 
Top