Skip to Content
Former Member
Aug 29, 2012 at 08:35 AM

OLE Excel



My requirement is to take data in excel and show to user .

There will be 5 columns in toto. 3 columns from sap and 2 has to be input by

the user . The two columns have validations . My requirement is user user

should not be allowed to copy and paste the data he is inputting as the

validation has to fire for every line of entry.

Mandatory user has to type the two rows. No copy paste allowed .

Got the property "CopyObjectswithcell = flase". But this works in a

macro but does not work through or from SAP.

How to do this ?

Thanks in advance.