"Web" Command Bar always appears on start up

  • Thread starter Thread starter ch
  • Start date Start date
C

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
 
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
Click to expand...
 
Back
Top