Skip to Content
avatar image
Former Member

OLE : To Block the Particular cell in Excel using OLE

Hi,

I have a requirement while using OLE i need to make particular cell Non Editable. Is there is any Method to set the property.

Thanks in Advance

Regards,

Sadiq

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • avatar image
    Former Member
    Sep 15, 2014 at 05:58 AM

      SET PROPERTY OF LO_SELECTION 'Locked' = 1.

    CALL METHOD OF       GO_WORKSHEET       'Protect'

    EXPORTING

          #01          = 0       #02          = 0.

    code here  Using ole2 objects for create an excel file

    Add comment
    10|10000 characters needed characters exceeded