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" wrote in message ...
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.