I am trying to disable the 'Insert' and 'View' of the worksheet menu bar with
the following codes -

Application.CommandBars("Insert").Enabled = false
Application.CommandBars("View").Enabled = false

but is having a problem; only 'View' is disabled but 'Insert' is not. Is
it because
"Insert" cannot be disabled in this manner? Is so, how can I disable
'Insert'.

Thank you.

Hi Ang,

Try this one :
CommandBars(1).Controls("insert").Enabled = False

Because Insert is a control of Worksheet Menu Bar is index=1
so I use 1
--

Regards,

Halim


"Francis Ang" wrote:

> I am trying to disable the 'Insert' and 'View' of the worksheet menu bar with
> the following codes -
>
> Application.CommandBars("Insert").Enabled = false
> Application.CommandBars("View").Enabled = false
>
> but is having a problem; only 'View' is disabled but 'Insert' is not. Is
> it because
> "Insert" cannot be disabled in this manner? Is so, how can I disable
> 'Insert'.
>
> Thank you.
>
>

Thanks alot Halim. Appreciate your help very much.

"Halim" wrote:

> Hi Ang,
>
> Try this one :
> CommandBars(1).Controls("insert").Enabled = False
>
> Because Insert is a control of Worksheet Menu Bar is index=1
> so I use 1
> --
>
> Regards,
>
> Halim
>
>
> "Francis Ang" wrote:
>
> > I am trying to disable the 'Insert' and 'View' of the worksheet menu bar with
> > the following codes -
> >
> > Application.CommandBars("Insert").Enabled = false
> > Application.CommandBars("View").Enabled = false
> >
> > but is having a problem; only 'View' is disabled but 'Insert' is not. Is
> > it because
> > "Insert" cannot be disabled in this manner? Is so, how can I disable
> > 'Insert'.
> >
> > Thank you.
> >
> >

Hi

Better to use Id numbers instead of the name
No problem if you run it in a non English version

See
http://www.rondebruin.nl/menuid.htm

--
Regards Ron de Bruin
http://www.rondebruin.nl



"Francis Ang" <(E-Mail Removed)> wrote in message news:F4DF9177-9DB4-4510-81C2-(E-Mail Removed)...
> Thanks alot Halim. Appreciate your help very much.
>
> "Halim" wrote:
>
>> Hi Ang,
>>
>> Try this one :
>> CommandBars(1).Controls("insert").Enabled = False
>>
>> Because Insert is a control of Worksheet Menu Bar is index=1
>> so I use 1
>> --
>>
>> Regards,
>>
>> Halim
>>
>>
>> "Francis Ang" wrote:
>>
>> > I am trying to disable the 'Insert' and 'View' of the worksheet menu bar with
>> > the following codes -
>> >
>> > Application.CommandBars("Insert").Enabled = false
>> > Application.CommandBars("View").Enabled = false
>> >
>> > but is having a problem; only 'View' is disabled but 'Insert' is not. Is
>> > it because
>> > "Insert" cannot be disabled in this manner? Is so, how can I disable
>> > 'Insert'.
>> >
>> > Thank you.
>> >
>> >

Hi Ron,

Thank you for the execellent tip. Appreciate it very much.

"Ron de Bruin" wrote:

> Hi
>
> Better to use Id numbers instead of the name
> No problem if you run it in a non English version
>
> See
> http://www.rondebruin.nl/menuid.htm
>
> --
> Regards Ron de Bruin
> http://www.rondebruin.nl
>
>
>
> "Francis Ang" <(E-Mail Removed)> wrote in message news:F4DF9177-9DB4-4510-81C2-(E-Mail Removed)...
> > Thanks alot Halim. Appreciate your help very much.
> >
> > "Halim" wrote:
> >
> >> Hi Ang,
> >>
> >> Try this one :
> >> CommandBars(1).Controls("insert").Enabled = False
> >>
> >> Because Insert is a control of Worksheet Menu Bar is index=1
> >> so I use 1
> >> --
> >>
> >> Regards,
> >>
> >> Halim
> >>
> >>
> >> "Francis Ang" wrote:
> >>
> >> > I am trying to disable the 'Insert' and 'View' of the worksheet menu bar with
> >> > the following codes -
> >> >
> >> > Application.CommandBars("Insert").Enabled = false
> >> > Application.CommandBars("View").Enabled = false
> >> >
> >> > but is having a problem; only 'View' is disabled but 'Insert' is not. Is
> >> > it because
> >> > "Insert" cannot be disabled in this manner? Is so, how can I disable
> >> > 'Insert'.
> >> >
> >> > Thank you.
> >> >
> >> >
>
>
>