Hyperlink problem in Excel 2000

  • Thread starter Thread starter Rashmi
  • Start date Start date
R

Rashmi

I'm having the following trouble with Excel 2000.

When I try to open hyperlinked Word 2000 documents from my
excel file, it open the word doc all right, but with an
additional toolbar (the Web toolbar) which wasn't there
when I saved the word doc. I remove the toolbar and save
the word document and again try to open it from the excel
file, and I again get the toolbar. After doing this, if I
try to even create a fresh new word document, the toolbar
is back!

It seems as if both these microsoft products remember the
way it was done most recently and use that. How do I stop
this?

I'm fed up. Can someone please help me?
 
Word does the same thing - and it not a bug, that's the
way it's supposed to work. The web toolbar appears
because you clicked on a hyperlink.

There are little blue arrows at the left of the web
toobar. Clicking on the left arrow takes you back to the
previous document - just like the Back button in a web
browser.

I sorta wish the web toolbars would go away when you're
done with the documents with the hyperlinks, but they
don't. If you do this a lot, you'll get use to it. It
doesn't really bother me anymore because I find the
hyperlinks so useful.
 
Open Excel
hit alt-F11 to get to the VBE
hit ctrl-G to see the immediate window

type this in:
application.CommandBars("web").Enabled = false

I couldn't get the web toolbar to show up--it didn't appear in the
tools|customize|toolbars dialog.

Remember to just change the false to true when/if you change your mind.

I went searching for the similar solution inside MSWord a couple of weeks ago.
One kind of neat suggestion was to use the Web toolbar as your own.

Get rid of the things you don't like. Add a few of your own favorite icons to
it. And show it all the time.

(the .enabled = false will work in msword, too.)
 
Back
Top