Web toolbar

[Jack Bowell]

I've created a custom toolbar in excel for my favorite files. Everytime I
use one of the links excel opens the web toolbar. Is there a way to disable
this from happening everytime?

 

[Beth Melton]

Hi Jack,

See if this macro takes care of it:

Sub KillWeb()
'Change False to True to enable the toolbar
With CommandBars("Web")
.Enabled = False
End With
End Sub

Depending on the version of Office you are using you may need to run
the macro each time Excel starts to keep it disabled.
--
Please post all follow-up questions to the newsgroup. Requests for
assistance by email can not be acknowledged.

~~~~~~~~~~~~~~~
Beth Melton
Microsoft Office MVP

Word FAQ: http://mvps.org/word
TechTrax eZine: http://mousetrax.com/techtrax/
MVP FAQ site: http://mvps.org/