hyperlink, unwanted web toolbar (XLXP)

Topic

New Reply

I have set up a hyperlink from one workbook to open a different workbook and go to a specified address. This works fine, but the target workbook is opened with the web toolbar displayed.
I didn’t ask for this.
How do I suppress it?

Reply | Quote

Replies

This is a “feature” of Office programs. You can disable the web toolbar as follows:
– Switch to the Visual Basic Editor (Alt+F11)
– Activate the Immediate window (Ctrl+G)
– Type Application.CommandBars(“Web”).Enabled = False then press Enter.
– Switch back to Excel.
You should only have to do this once. If you ever want to enable the web toolbar again, repeat the above with … = True instead of … = False.

Reply | Quote

Where, Hans?
Having done what you described (I think!), the contents of the Immediate window are:

[auto_open] <
[SetupFunctionIDs]
[PickPlatform]
[VerifyOpen] 1
[RegisterFunctionIDs]
[auto_open] >
Application.CommandBars(“Web”).Enabled = False

Regretfully, this has not suppressed the feature.
Sorry if I’m thick.

Reply | Quote

The first lines are debug information from loading the Analysis Toolpak (or its VBA counterpart), you can ignore or delete them.
Just to make sure, click anywhere in the line
Application.Commandbars(“Web”).Enabled=False
Then press Enter. If that doesn’t help, I don’t know, sorry.

Reply | Quote

The first lines are debug information from loading the Analysis Toolpak (or its VBA counterpart), you can ignore or delete them.
Just to make sure, click anywhere in the line
Application.Commandbars(“Web”).Enabled=False
Then press Enter. If that doesn’t help, I don’t know, sorry.

Reply | Quote

Thanks, Hans, that works ok on different machine, here, where there was nothing in the Immediate window.
Will do your remedy on home box tonight.
(How do you and the other gurus find out this arcane sort of stuff?)

Reply | Quote

>> How do you and the other gurus find out this arcane sort of stuff?

By visiting Woody’s Lounge, of course

(and by searching the Microsoft Newsgroups, the MVP site, John Walkenbach’s site, Chip Pearson’s site etc., and last but not least by experimenting.)

Reply | Quote

>> How do you and the other gurus find out this arcane sort of stuff?

By visiting Woody’s Lounge, of course

(and by searching the Microsoft Newsgroups, the MVP site, John Walkenbach’s site, Chip Pearson’s site etc., and last but not least by experimenting.)

Reply | Quote

And works ok on the other one, too, having rubbed out existing stuff.
Thanks again.

Reply | Quote

And works ok on the other one, too, having rubbed out existing stuff.
Thanks again.

Reply | Quote

Thanks, Hans, that works ok on different machine, here, where there was nothing in the Immediate window.
Will do your remedy on home box tonight.
(How do you and the other gurus find out this arcane sort of stuff?)

Reply | Quote

Where, Hans?
Having done what you described (I think!), the contents of the Immediate window are:

[auto_open] <
[SetupFunctionIDs]
[PickPlatform]
[VerifyOpen] 1
[RegisterFunctionIDs]
[auto_open] >
Application.CommandBars(“Web”).Enabled = False

Regretfully, this has not suppressed the feature.
Sorry if I’m thick.

Reply | Quote

This is a “feature” of Office programs. You can disable the web toolbar as follows:
– Switch to the Visual Basic Editor (Alt+F11)
– Activate the Immediate window (Ctrl+G)
– Type Application.CommandBars(“Web”).Enabled = False then press Enter.
– Switch back to Excel.
You should only have to do this once. If you ever want to enable the web toolbar again, repeat the above with … = True instead of … = False.

Hi Hans,
I had the same problem. This worked great at home, but didn’t make any difference at work. At work, the Excel program (2003) is on a Wan (along with all the spreadsheets), wonder if that makes a difference. Since you have to logon to the Wan, it does keep my special toolbars and macros the way I set them up though.

The only thing currently under “Immediate” is the “Application.CommandBars(“Web”).Enabled = False” that I entered.

Any other ideas?

Thanks

Reply | Quote

Do you have a personal macro workbook Personal.xls of your own? If not, it’ll be difficult.

Reply | Quote

Hans,

Yes I do. My toolbar has icons that activate macros in the Personal.xls.

Reply | Quote

Try the following:

– Start Excel.
– Press Alt+F11 to activate the Visual Basic Editor.
– Double-click the ThisWorkbook node under Personal.xls in the project explorer on the left hand side.
– Copy the following code into the module that appears:

Private Sub Workbook_Open()
Application.CommandBars(“Web”).Enabled = False
End Sub

– This code will run automatically each time you start Excel.

Reply | Quote

Hi Hans,

Once again you’ve worked miracles. Worked perfectly.

Thanks so much.

Reply | Quote

This is a “feature” of Office programs. You can disable the web toolbar as follows:
– Switch to the Visual Basic Editor (Alt+F11)
– Activate the Immediate window (Ctrl+G)
– Type Application.CommandBars(“Web”).Enabled = False then press Enter.
– Switch back to Excel.
You should only have to do this once. If you ever want to enable the web toolbar again, repeat the above with … = True instead of … = False.

Reply | Quote