Disable "Delete" from row menu...

[smck]

Hello,

I am trying to disable the menu item "Delete" when an entire row is selected.

I tried this code

Please Login or Register  to view this content.

It will not compile... I ahve tried searching everywhere online but to no avail.

What am I doing wrong?

Thanks

[Leith Ross]

Hello smck,

When identifying a CommandBarControl by name, you have to use a special character to denote the underscored letter, like Delete

To do this, precede the letter that is underscored with an Ampersand character.

Please Login or Register  to view this content.

Note: Since this CommandBar is a Popup, one or Rows must be selected before the code is executed.

[smck]

Thanks,

With regards to your note (in red) would I have to make this trigger from an event? I have trying to have this code executed as soon as the workbook opens, but it will not work.

My goal is to restrict users from doing the following:

Insert, and delete columns.
Delete rows.. (They will still be allowed to insert rows however)

Any additional advise?

Thanks