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, mpros...@sherrittoil.com 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


<(E-Mail Removed)> wrote in message news:(E-Mail Removed)...
> 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" <rondebr...@kabelfoon.nl> wrote:
> Hi siicl
>
> If you not want to see this bar then use
>
> .Enabled = False
>
> --
>
> Regards Ron de Bruinhttp://www.rondebruin.nl/tips.htm
>
>
>
> <mpros...@sherrittoil.com> wrote in messagenews:(E-Mail Removed)...
> > 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!

View>Toolbars>Uncheck Web

"(E-Mail Removed)" 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
>
>