"Web" Command Bar always appears on start up

[ch]

Hi all,

I have created a icon on my <Standard> command bar, when I clik, it link to
another spread sheet which will open up.

This works fine, except that each time the linked spread sheet opens up, it
also turns on the "Web" Command bar, and I have to clik the "x" on the
command bar to hide it.

How can I prevent this?

I have tried adding these following lines to the Microsoft Excel Objects >
ThisWorkbook but it doesn't work.

Private Sub Workbook_Open()
Application.CommandBars("Web").Visible = False
End Sub

 

[Dave Peterson]

How about trying .enabled instead of .visible?

Hi all,

I have created a icon on my <Standard> command bar, when I clik, it link to
another spread sheet which will open up.

This works fine, except that each time the linked spread sheet opens up, it
also turns on the "Web" Command bar, and I have to clik the "x" on the
command bar to hide it.

How can I prevent this?

I have tried adding these following lines to the Microsoft Excel Objects >
ThisWorkbook but it doesn't work.

Private Sub Workbook_Open()
Application.CommandBars("Web").Visible = False
End Sub

 

[ch]

It Worked! Thanks.