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?

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?

Office/Excel 2003 - Stop toolbars automatically opening
 

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

-----Original Message-----
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?




.