When I open an xl file the "web" commandbar always open too. How do I
get get it not to do this?

I tried

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

and it doesn't seem to do anything.

Thx
siicl

I use the following without a problem:
If Application.CommandBars("Web").Visible = True Then
Application.CommandBars("Web").Visible = False



On Feb 15, 2:35 pm, wrote:
When I open an xl file the "web" commandbar always open too. How do I
get get it not to do this?

I tried

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

and it doesn't seem to do anything.

Thx
siicl

Hi siicl

If you not want to see this bar then use

..Enabled = False


--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


wrote in message oups.com...
When I open an xl file the "web" commandbar always open too. How do I
get get it not to do this?

I tried

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

and it doesn't seem to do anything.

Thx
siicl

On Feb 15, 7:59 am, "Ron de Bruin" wrote:
Hi siicl

If you not want to see this bar then use

.Enabled = False

--

Regards Ron de Bruinhttp://www.rondebruin.nl/tips.htm



wrote in ooglegroups.com...
When I open an xl file the "web" commandbar always open too. How do I
get get it not to do this?

I tried

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

and it doesn't seem to do anything.

Thx
siicl- Hide quoted text -

- Show quoted text -

Works! Thanks alot!

ViewToolbarsUncheck Web

" wrote:

When I open an xl file the "web" commandbar always open too. How do I
get get it not to do this?

I tried

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

and it doesn't seem to do anything.

Thx
siicl