topic Problem with Protected Excel sheets through OLE in Application Development and Automation Discussions https://community.sap.com/t5/application-development-and-automation-discussions/problem-with-protected-excel-sheets-through-ole/m-p/5602502#M1276782 <HTML><HEAD></HEAD><BODY><P>Hi Friends</P><P></P><P>We are facing the problem with the protected sheets in excel, when we are accessing worksheets via SAP. </P><P></P><P>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.</P><P></P><P>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.</P><P></P><P>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.</P><P></P><P>Please give me any suggestions.</P><P></P><P>Thanks</P><P>Praveen</P></BODY></HTML> Mon, 11 May 2009 06:06:00 GMT praveen_hannu 2009-05-11T06:06:00Z Problem with Protected Excel sheets through OLE https://community.sap.com/t5/application-development-and-automation-discussions/problem-with-protected-excel-sheets-through-ole/m-p/5602502#M1276782 <HTML><HEAD></HEAD><BODY><P>Hi Friends</P><P></P><P>We are facing the problem with the protected sheets in excel, when we are accessing worksheets via SAP. </P><P></P><P>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.</P><P></P><P>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.</P><P></P><P>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.</P><P></P><P>Please give me any suggestions.</P><P></P><P>Thanks</P><P>Praveen</P></BODY></HTML> Mon, 11 May 2009 06:06:00 GMT https://community.sap.com/t5/application-development-and-automation-discussions/problem-with-protected-excel-sheets-through-ole/m-p/5602502#M1276782 praveen_hannu 2009-05-11T06:06:00Z Re: Problem with Protected Excel sheets through OLE https://community.sap.com/t5/application-development-and-automation-discussions/problem-with-protected-excel-sheets-through-ole/m-p/5602503#M1276783 <HTML><HEAD></HEAD><BODY><P>its bug with ECC 5.0. If we want to make it auto fit we need to unprotect, then auto fit.</P><P>Later we can protect again</P></BODY></HTML> Mon, 02 Nov 2009 07:38:35 GMT https://community.sap.com/t5/application-development-and-automation-discussions/problem-with-protected-excel-sheets-through-ole/m-p/5602503#M1276783 praveen_hannu 2009-11-02T07:38:35Z