topic Re: Problem to Script execute the macro - macro to export sheets as image in QlikView https://community.qlik.com/t5/QlikView/Problem-to-Script-execute-the-macro-macro-to-export-sheets-as/m-p/1260452#M851244 <HTML><HEAD></HEAD><BODY><P>Sorry for the late post, but I figured out a while ago.</P><P>The case the macro didn't execute properly was becuse I was using the type of view where I could see all the sheets.</P><P>When I unselected the option Show all sheets and objects in Security on Document's properties it all went fine. </P></BODY></HTML> Thu, 26 Oct 2017 16:15:35 GMT Anonymous 2017-10-26T16:15:35Z Problem to Script execute the macro - macro to export sheets as image https://community.qlik.com/t5/QlikView/Problem-to-Script-execute-the-macro-macro-to-export-sheets-as/m-p/1260450#M851242 <HTML><HEAD></HEAD><BODY><P>hi everyone, I'm having an issue with Qlikview where my project have some sheets and I need that in the execution of my script, it execute the macro of my project where my macro will export an image of each one fom my sheets.</P><P></P><P></P><P>on my macro I have de code and te macro execute when I go Through the sheets.</P><P>the export function is working but is doesn't run when I execute the script.</P><P>can anyone help me??</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Problem-to-Script-execute-the-macro-macro-to-export-sheets-as/m-p/1260450#M851242 Anonymous 2020-11-25T16:16:04Z Re: Problem to Script execute the macro - macro to export sheets as image https://community.qlik.com/t5/QlikView/Problem-to-Script-execute-the-macro-macro-to-export-sheets-as/m-p/1260451#M851243 <HTML><HEAD></HEAD><BODY><P>You have to call the activate method of the sheet</P><P>ex:</P><P><STRONG>ActiveDocument.Sheets("Market").Activate</STRONG></P><P></P><P>set newsheet=ActiveDocument.CreateSheet</P><P>set sp=newsheet.GetProperties</P><P>sp.Name="abc"</P><P>newsheet.setProperties sp</P><P>newsheet.Activate</P></BODY></HTML> Fri, 17 Mar 2017 10:34:50 GMT https://community.qlik.com/t5/QlikView/Problem-to-Script-execute-the-macro-macro-to-export-sheets-as/m-p/1260451#M851243 sasiparupudi1 2017-03-17T10:34:50Z Re: Problem to Script execute the macro - macro to export sheets as image https://community.qlik.com/t5/QlikView/Problem-to-Script-execute-the-macro-macro-to-export-sheets-as/m-p/1260452#M851244 <HTML><HEAD></HEAD><BODY><P>Sorry for the late post, but I figured out a while ago.</P><P>The case the macro didn't execute properly was becuse I was using the type of view where I could see all the sheets.</P><P>When I unselected the option Show all sheets and objects in Security on Document's properties it all went fine. </P></BODY></HTML> Thu, 26 Oct 2017 16:15:35 GMT https://community.qlik.com/t5/QlikView/Problem-to-Script-execute-the-macro-macro-to-export-sheets-as/m-p/1260452#M851244 Anonymous 2017-10-26T16:15:35Z