Disabling Toolbar

[Francis Ang]

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.

 

[Halim]

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

 

[Francis Ang]

Thanks alot Halim. Appreciate your help very much.

 

[Ron de Bruin]

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

 

[Francis Ang]

Hi Ron,

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