Skip to Content
0
Former Member
Sep 09, 2010 at 06:15 PM

Disable button on ribbon on BPS Layout (Excel 2007)

24 Views

Hello,

We have a BPS Layout with SAP standard macros enabled (Modul1.SAPAfterDataPut and Modul1.SAPBeforeDataGet enabled).

These macros do several useful things like protecting cells and disabling "Sort & Filter" option on Excel 2007 ribbon.

But additionally it is required to disable copy/cut/paste buttons on ribbon.

Do you know how to do it?

I've searched for "Sort & Filter" disabling on SAP standard macros but I didn't find anything. Knowing that, I would know how to do similar thing for other buttons...

(edit: unfortunately hiding the complete ribbon via macro is not an option)

Has anyone done any kind of similar change on ribbon?

Many thanks in advance,

Rui

Edited by: Rui Ramos on Sep 9, 2010 10:26 PM