topic Lock Excel doc from macro? in QlikView https://community.qlik.com/t5/QlikView/Lock-Excel-doc-from-macro/m-p/399465#M148643 <HTML><HEAD></HEAD><BODY><P>Hi All,</P><P></P><P>I have a macro that exports data to excel and emails it to a list of users. I need to lock the Excel doc to prevent users from editing data.</P><P></P><P>Any Ideas?</P></BODY></HTML> Thu, 23 May 2013 08:18:11 GMT 2013-05-23T08:18:11Z Lock Excel doc from macro? https://community.qlik.com/t5/QlikView/Lock-Excel-doc-from-macro/m-p/399465#M148643 <HTML><HEAD></HEAD><BODY><P>Hi All,</P><P></P><P>I have a macro that exports data to excel and emails it to a list of users. I need to lock the Excel doc to prevent users from editing data.</P><P></P><P>Any Ideas?</P></BODY></HTML> Thu, 23 May 2013 08:18:11 GMT https://community.qlik.com/t5/QlikView/Lock-Excel-doc-from-macro/m-p/399465#M148643 2013-05-23T08:18:11Z Re: Lock Excel doc from macro? https://community.qlik.com/t5/QlikView/Lock-Excel-doc-from-macro/m-p/399466#M148644 <HTML><HEAD></HEAD><BODY><P>This thread should be able to help you with the final step of your macro:</P><P></P><P><A class="loading" href="http://www.mrexcel.com/forum/excel-questions/81185-protect-unprotect-worksheet-through-visual-basic-applications.html" title="http://www.mrexcel.com/forum/excel-questions/81185-protect-unprotect-worksheet-through-visual-basic-applications.html">http://www.mrexcel.com/forum/excel-questions/81185-protect-unprotect-worksheet-through-visual-basic-applications.html</A></P></BODY></HTML> Thu, 23 May 2013 08:24:03 GMT https://community.qlik.com/t5/QlikView/Lock-Excel-doc-from-macro/m-p/399466#M148644 calvindk 2013-05-23T08:24:03Z Re: Lock Excel doc from macro? https://community.qlik.com/t5/QlikView/Lock-Excel-doc-from-macro/m-p/399467#M148645 <HTML><HEAD></HEAD><BODY><P>Thanks for your response Anders,</P><P></P><P>The example in that thread seems pretty complex. All I need to do is lock the entire sheet.</P><P></P><P>Any Ideas?</P></BODY></HTML> Thu, 23 May 2013 08:30:22 GMT https://community.qlik.com/t5/QlikView/Lock-Excel-doc-from-macro/m-p/399467#M148645 2013-05-23T08:30:22Z Re: Lock Excel doc from macro? https://community.qlik.com/t5/QlikView/Lock-Excel-doc-from-macro/m-p/399468#M148646 <HTML><HEAD></HEAD><BODY><P>Only take the lock part. You are not getting around using VBA from what i can tell.</P></BODY></HTML> Thu, 23 May 2013 09:56:06 GMT https://community.qlik.com/t5/QlikView/Lock-Excel-doc-from-macro/m-p/399468#M148646 calvindk 2013-05-23T09:56:06Z