Automatic Toolbar

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Michelle - 20 Jan 2008 09:28 GMT

Hello, I posted this question on Excel.Misc a while ago, but everyone
ignored it, I'm really desperate for a solution... any ideas:

I use hyperlinks to other documents, but I don't want the Web toolbar to
come up everytime I use them.Can I switch that automatic feature off? I
don't want to know how to turn a toolbar off (I've done that a thousand
times)! I want to know how to stop it from coming on automatically each time
I follow a hyperlink.

Any ideas? Please...

M

Reply to this Message

Bill Manville - 20 Jan 2008 11:11 GMT

A VBA solution which would prevent the Web toolbar from being shown (at
all) would be:
Application.CommandBars("Web").Enabled = False

If you wanted to disable it only when a particular workbook was open
you could put this in its Workbook_Open procedure in ThisWorkbook
and
Application.CommandBars("Web").Enabled = True
in Workbook_BeforeClose

Bill Manville
MVP - Microsoft Excel, Oxford, England
No email replies please - respond to newsgroup

Reply to this Message

Michelle - 21 Jan 2008 08:13 GMT

thanks Bill, I think that's fixed it!

M

>A VBA solution which would prevent the Web toolbar from being shown (at
> all) would be:
[quoted text clipped - 9 lines]
> MVP - Microsoft Excel, Oxford, England
> No email replies please - respond to newsgroup

Reply to this Message

christopher@heavey.co.uk - 29 Jan 2008 13:45 GMT

ah, such a relief to not have that damn toolbar opening every time I
use a hyperlink.

Thanks Bill (and Michelle for asking the question)

Chris

Reply to this Message