Skip to Content
Nov 26, 2011 at 01:36 PM

Excel using OLE : Protect cells and insert rows


Hi All,

I am downloading an excel from an ABAP program using OLE automation.

I am protecting few cells in the excel (not the entire sheet) but this does not allow me to insert rows in the excel.

How can we protect few cells as well as insert rows in the sheet?

Or, as an alternative is it possible to set the cells as invisible ? How do we set the 'invisible' property for selected range of cells?

Though, this issue is already discussed in SDN i could'nt find solution for the same.

Kinldy help me with your inputs.

Thanks ,