I have been able to hide most other context menu options such as “Insert” or “Delete” etc. But there area few that I cannot seem to get rid of and I am starting to wonder if it is not possible.

Under normal circumstances, when right clicking on a cell in Excel you get a shortcut menu. I have been using VBA in Excel to remove many of these when the excel workbook activates and restoring them when it closes.

What I have been using to remove them is something like this in a subroutine for example:

Application.CommandBars("Cell").Controls("Filter").Visible = False

I can cycle through all of the items in the controls collection and remove them all except for:

-New Comment
-New Note
-Link

It does have a hyperlink item in the collection that I have hidden but it doesn’t seem to affect this link option. There also is an insert comment item in the collection but that also does not turn this new comment off.

Any ideas?