This of course works but leaves behind the annoying 'Paste Options' submenu. How can I get rid of this ?
Sub removeCellMenuItems() Dim cbcCurControl As CommandBarControl For Each cbcCurControl In CommandBars("Cell").Controls If cbcCurControl.BuiltIn Then cbcCurControl.Visible = False Next cbcCurControl End Sub
Gain unlimited access to on-demand training courses with an Experts Exchange subscription.Get Access
When asked, what has been your best career decision?
Deciding to stick with EE.
Being involved with EE helped me to grow personally and professionally.