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?

ch wrote:

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

It Worked! Thanks.