Problem with Protected Excel sheets through OLE

[praveen_hannu]

Hi Friends

We are facing the problem with the protected sheets in excel, when we are accessing worksheets via SAP.

We can insert the values in the protected sheet and we can do other manupalations, but when we are trying to do the autofit for the protected sheet via SAP, then its throwing an error while making it as Visible in SAP ECC 6.0.

Though it is valid, because even when we do in the excel itself, it wont allow the user to shrink the columns, but this one is possible in ECC 5.0 and we can make excel is visible on the screen.

I would like to know is this SAP Version problem or anything else apart from this? and I would like to know is there anyway to unprotect and protect the sheet through ABAP program with out a password. Now my clients wants the autofit though its protected.

Please give me any suggestions.

Thanks

Praveen

[praveen_hannu]

its bug with ECC 5.0. If we want to make it auto fit we need to unprotect, then auto fit.

Later we can protect again