View Single Post
  #8   Report Post  
Posted to microsoft.public.excel.misc
Dave Peterson Dave Peterson is offline
external usenet poster
 
Posts: 35,218
Default Clicking hyperlink causes toolbar to show

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.

TerryTutor wrote:

Didn't work...

The Ctrl-G puts you in the immediate window. This didnt work, even if I
restarted Excel. So I put it in the code window. That didnt work because
there wasnt a named macro. So I gave the macro (code) a name, did an End
Sub at the end. It didnt work, even when I restarted Excel.

"Dave Peterson" wrote:

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.)

TerryTutor wrote:

Anytime I click on a hyperlink in Excel, it automatically opens my web
toolbar. Is there a way to stop that?


--

Dave Peterson


--

Dave Peterson