https://community.qlik.com/t5/QlikView/NPrinting-Excel-Macro-error/m-p/1742671#M1232402 <P>Try it with .activate the worksheet instead of .select</P><P>- Marcus</P> Thu, 10 Sep 2020 07:26:29 GMT marcus_sommer 2020-09-10T07:26:29Z https://community.qlik.com/t5/QlikView/NPrinting-Excel-Macro-error/m-p/1742651#M1232400 <P>Hi All,</P><P>Thanks for taking time and reading this. I am trying to put a macro in NPrinting excel template, it works fine when I preview it as ".xlsm" file but after publishing it and trying to open from email it throws error. I am trying to collapse the first column of pivotables using this macro,&nbsp; Following&nbsp; is the macro and error I am getting trying to open from email</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Macro" style="width: 531px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/40334i9DB5B9090A752F79/image-dimensions/531x115?v=v2" width="531" height="115" role="button" title="Macro.PNG" alt="Macro" /><span class="lia-inline-image-caption" onclick="event.preventDefault();">Macro</span></span><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="excel error" style="width: 388px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/40335i6F13A4FA2414A5CE/image-dimensions/388x284?v=v2" width="388" height="284" role="button" title="error.PNG" alt="excel error" /><span class="lia-inline-image-caption" onclick="event.preventDefault();">excel error</span></span></P><P>Thanks,</P><P>Sikander</P> Mon, 26 Jan 2026 16:26:21 GMT https://community.qlik.com/t5/QlikView/NPrinting-Excel-Macro-error/m-p/1742651#M1232400 sikander02 2026-01-26T16:26:21Z https://community.qlik.com/t5/QlikView/NPrinting-Excel-Macro-error/m-p/1742671#M1232402 <P>Try it with .activate the worksheet instead of .select</P><P>- Marcus</P> Thu, 10 Sep 2020 07:26:29 GMT https://community.qlik.com/t5/QlikView/NPrinting-Excel-Macro-error/m-p/1742671#M1232402 marcus_sommer 2020-09-10T07:26:29Z