Pop up menu headache

[PhilSM]

Whenever I use a hyperlink to open another spreadsheet Excel adds a menu (web) to my menu bar.
I can then remove it but it reappears again everytime.
No matter what I do it always reappears.
It isn't a problem just very annoying.

How can I stop this happening ?

Excel 2003 SP3

[arthurbr]

Hi and welcome to the board.
Is there any macro in your wbook which would cause this?

[PhilSM]

Hi arthurbr

No there are no macro's in my wbook.

[romperstomper]

There is no option to turn this off that I know of. Your only choice would be to write some code to disable the web toolbar I think.

[PhilSM]

Could you suggest some code please ?

Thanks for help.
Phil

[Andy Pope]

This code will turn off the web toolbar

Private Sub Workbook_SheetFollowHyperlink(ByVal Sh As Object, ByVal Target As Hyperlink)

    Application.CommandBars("web").Visible = False

End Sub

Difficult part is knowing where to put. If you only want to worry about the workbook with the links in then add it to the Thisworkbook object of that project.
If it's for any link then you will need to create an addin with application level events.

[PhilSM]

Thanks Andy