View Single Post
  #13   Report Post  
Posted to microsoft.public.excel.misc
Damon Damon is offline
external usenet poster
 
Posts: 30
Default Clicking hyperlink causes toolbar to show

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!!

"Dave Peterson" wrote:

Maybe you could create your own customized web toolbar (MyWeb). Then disable
excel's.

TerryTutor wrote:

Yes, unfortunately I do use the toolbar from time to time.

"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