Clicking hyperlink causes toolbar to show

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Anytime I click on a hyperlink in Excel, it automatically opens my web
toolbar. Is there a way to stop that?
 
Thanks for your suggestion, but toolbar shows up docked immediately under the
formatting toolbar.
 
Do you use the web toolbar at all?

If no, then maybe you could disable it:

You could just enter a command from the VBE immediate window:

Hit alt-f11
hit ctrl-g
type this and hit enter:
Application.CommandBars("web").Enabled = False
And close this window and try it out.

Change False to True when you decide you want it back.

(I didn't test this. Please post back with your results.)
 
Maybe you could create your own customized web toolbar (MyWeb). Then disable
excel's.
 
Didn't work...

The Ctrl-G puts you in the immediate window. This didn’t work, even if I
restarted Excel. So I put it in the code window. That didn’t’ work because
there wasn’t a named macro. So I gave the macro (code) a name, did an End
Sub at the end. It didn’t work, even when I restarted Excel.
 
Do you mean that the command you entered in the immediate window (or the sub)
didn't run?

Or do you mean that the command ran ok, but didn't do what you wanted?

For me (xl2003), the command ran nicely--no errors popped up.

And when I went to excel, then tools|Customize|toolbars tab, Web didn't even
appear in the list that was displayed.
 
I thought that disabling the Web toolbar would stop that toolbar from showing up
-- no matter what the link pointed to.
 
From the person I was trying to help:

Okay, it’s 4:30 am when things should make no sense. Now it works. I don’t
understand why it wouldn’t work last night. But it works this morning.

Thanks for the help!
 
I'd bet there was at least one typo in the first efforts.
From the person I was trying to help:

Okay, it’s 4:30 am when things should make no sense. Now it works. I don’t
understand why it wouldn’t work last night. But it works this morning.

Thanks for the help!
Click to expand...
 
Thank you Dave that is exactly what I wanted. The Web toolbar was really
getting to me. Even when docked it would still jump down a line when I used
a hyperlink (which I do a lot at work).

I like having the full path of the file I am working on shown in the address
box as we experiment with macros on copies of files before editing the live
documents, and it's good to have the quick glance check that I am looking at
the right one

I nearly made a post about it but I searched an found this first saving me
the trouble!

Cheers!!
 
Back
Top