topic Re: Lock boxes in ole2_object in Application Development and Automation Discussions https://community.sap.com/t5/application-development-and-automation-discussions/lock-boxes-in-ole2-object/m-p/8828468#M1682920 <HTML><HEAD></HEAD><BODY><P>Hi cristiano,</P><P></P><P></P><P>use below code to lock cell</P><P></P><P><SPAN class="L0S52">CALL</SPAN> <SPAN class="L0S52">METHOD</SPAN> <SPAN class="L0S52">OF</SPAN> h_excel <SPAN class="L0S33">'Cells'</SPAN> = h_cell</P><P>&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="L0S52">EXPORTING</SPAN></P><P>&nbsp;&nbsp;&nbsp;&nbsp; #<SPAN class="L0S32">1</SPAN> = <SPAN class="L0S52">i&nbsp;&nbsp;&nbsp; row number</SPAN></P><P>&nbsp;&nbsp;&nbsp;&nbsp; #<SPAN class="L0S32">2</SPAN> = j.&nbsp;&nbsp; column number</P><P></P><P></P><P>&nbsp;&nbsp; <SPAN class="L0S52">SET</SPAN> <SPAN class="L0S52">PROPERTY</SPAN> <SPAN class="L0S52">OF</SPAN> h_cell <SPAN class="L0S33">'FreezePanes'</SPAN> = 1.</P><P></P><P></P><P>Thanks,</P><P>Ashwath.</P></BODY></HTML> Mon, 25 Jun 2012 09:42:31 GMT Former Member 2012-06-25T09:42:31Z Lock boxes in ole2_object https://community.sap.com/t5/application-development-and-automation-discussions/lock-boxes-in-ole2-object/m-p/8828465#M1682917 <HTML><HEAD></HEAD><BODY><P>How can I insert "lock boxes" in ole2_object?&nbsp;&nbsp; </P><P></P><P>CREATE OBJECT excel 'Excel.Application'.&nbsp;&nbsp; </P><P>IF sy-subrc NE 0.&nbsp;&nbsp;&nbsp;&nbsp; </P><P>&nbsp; stop.&nbsp;&nbsp; </P><P>Endif.&nbsp;&nbsp; </P><P>Set Property excel OF 'Visible' = 0.</P><P>CALL METHOD OF excel 'Workbooks' = workbook.&nbsp;&nbsp; </P><P><SPAN class="L1S52">CALL <SPAN class="L1S52">METHOD</SPAN> <SPAN class="L1S52">OF</SPAN> workbook <SPAN class="L1S33">'Add'</SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; = map.</SPAN></P><P><SPAN class="L1S52"></SPAN> ......</P><P> Insert the value</P><P> ........ ......&nbsp;&nbsp; </P><P>CALL METHOD OF EXCEL 'Columns' = COLUMN.&nbsp;&nbsp; </P><P>CALL METHOD OF COLUMN 'Autofit'. ........ </P><P></P><P>LOCK BOXES?????????????? </P><P></P><P>Thanks. </P><P>CV</P></BODY></HTML> Mon, 25 Jun 2012 07:08:29 GMT https://community.sap.com/t5/application-development-and-automation-discussions/lock-boxes-in-ole2-object/m-p/8828465#M1682917 Former Member 2012-06-25T07:08:29Z Re: Lock boxes in ole2_object https://community.sap.com/t5/application-development-and-automation-discussions/lock-boxes-in-ole2-object/m-p/8828466#M1682918 <HTML><HEAD></HEAD><BODY><P>Are you talking about Protecting cells?</P><P>If yes, then check this link.</P><P><A _jive_internal="true" href="https://answers.sap.com/message/712260">http://scn.sap.com/message/712260</A></P><P></P><P>Thanks,<BR />Shambu</P></BODY></HTML> Mon, 25 Jun 2012 08:38:09 GMT https://community.sap.com/t5/application-development-and-automation-discussions/lock-boxes-in-ole2-object/m-p/8828466#M1682918 Former Member 2012-06-25T08:38:09Z Re: Lock boxes in ole2_object https://community.sap.com/t5/application-development-and-automation-discussions/lock-boxes-in-ole2-object/m-p/8828467#M1682919 <HTML><HEAD></HEAD><BODY><P>Ciao Shambu, I do this:</P><P></P><P><IMG class="migrated-image" src="https://community.sap.com/legacyfs/online/storage/attachments/storage/7/jiveimages/113440" height="91" width="482" /></P><P></P><P>Thanks a lot.</P></BODY></HTML> Mon, 25 Jun 2012 09:19:02 GMT https://community.sap.com/t5/application-development-and-automation-discussions/lock-boxes-in-ole2-object/m-p/8828467#M1682919 Former Member 2012-06-25T09:19:02Z Re: Lock boxes in ole2_object https://community.sap.com/t5/application-development-and-automation-discussions/lock-boxes-in-ole2-object/m-p/8828468#M1682920 <HTML><HEAD></HEAD><BODY><P>Hi cristiano,</P><P></P><P></P><P>use below code to lock cell</P><P></P><P><SPAN class="L0S52">CALL</SPAN> <SPAN class="L0S52">METHOD</SPAN> <SPAN class="L0S52">OF</SPAN> h_excel <SPAN class="L0S33">'Cells'</SPAN> = h_cell</P><P>&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="L0S52">EXPORTING</SPAN></P><P>&nbsp;&nbsp;&nbsp;&nbsp; #<SPAN class="L0S32">1</SPAN> = <SPAN class="L0S52">i&nbsp;&nbsp;&nbsp; row number</SPAN></P><P>&nbsp;&nbsp;&nbsp;&nbsp; #<SPAN class="L0S32">2</SPAN> = j.&nbsp;&nbsp; column number</P><P></P><P></P><P>&nbsp;&nbsp; <SPAN class="L0S52">SET</SPAN> <SPAN class="L0S52">PROPERTY</SPAN> <SPAN class="L0S52">OF</SPAN> h_cell <SPAN class="L0S33">'FreezePanes'</SPAN> = 1.</P><P></P><P></P><P>Thanks,</P><P>Ashwath.</P></BODY></HTML> Mon, 25 Jun 2012 09:42:31 GMT https://community.sap.com/t5/application-development-and-automation-discussions/lock-boxes-in-ole2-object/m-p/8828468#M1682920 Former Member 2012-06-25T09:42:31Z