Hi,

Could someone tell me why
MsgBox Application.CommandBars("Cell").Controls("Insert.. .").ID
is giving me a invalid procedure call or argument error.

I'm actually trying to disable insert and delete from Cell and Row right
click.

The delete is working fine
Application.CommandBars("Cell").Controls("Delete.. .").enable = False, but
insert gives me the error....

Help
wAyne_

Works fine for me.

--

HTH

Bob Phillips

(remove nothere from the email address if mailing direct)

"wAyne" wrote in message
...
Hi,

Could someone tell me why
MsgBox Application.CommandBars("Cell").Controls("Insert.. .").ID
is giving me a invalid procedure call or argument error.

I'm actually trying to disable insert and delete from Cell and Row right
click.

The delete is working fine
Application.CommandBars("Cell").Controls("Delete.. .").enable = False, but
insert gives me the error....

Help
wAyne_

I think you delete it

Run this one time
Application.CommandBars("Cell").Reset

And then try this

Application.CommandBars("Cell").FindControl(ID:=31 81).Enabled = False
Application.CommandBars("Cell").FindControl(ID:=29 2).Enabled = False




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


"wAyne" wrote in message ...
Hi,

Could someone tell me why
MsgBox Application.CommandBars("Cell").Controls("Insert.. .").ID
is giving me a invalid procedure call or argument error.

I'm actually trying to disable insert and delete from Cell and Row right
click.

The delete is working fine
Application.CommandBars("Cell").Controls("Delete.. .").enable = False, but
insert gives me the error....

Help
wAyne_

Hi,

I thought that might be the case -- I had it reset in an earlier part of the
code -- moved it to just before and had the same problems. I then copied
part of the code to a new workbook -- still same result -- even using the IDs
you provided (thanks Ron), I still end up with the same error.....
aaaarrrggghhhh!!

here is my sample code....

Sub test()

Application.CommandBars("Cell").Reset

Application.CommandBars("Cell").FindControl(ID:=29 2).Enabled = False

Application.CommandBars("Cell").Controls("Delete.. .").Enabled = False
Application.CommandBars("Cell").Controls("Insert.. .").Enabled = False

Application.CommandBars("Cell").FindControl(ID:=31 81).Enabled = False

End Sub


Thanks
wAyne_

"Ron de Bruin" wrote:

I think you delete it

Run this one time
Application.CommandBars("Cell").Reset

And then try this

Application.CommandBars("Cell").FindControl(ID:=31 81).Enabled = False
Application.CommandBars("Cell").FindControl(ID:=29 2).Enabled = False




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


"wAyne" wrote in message ...
Hi,

Could someone tell me why
MsgBox Application.CommandBars("Cell").Controls("Insert.. .").ID
is giving me a invalid procedure call or argument error.

I'm actually trying to disable insert and delete from Cell and Row right
click.

The delete is working fine
Application.CommandBars("Cell").Controls("Delete.. .").enable = False, but
insert gives me the error....

Help
wAyne_