topic Macro - readonly multibox field in QlikView https://community.qlik.com/t5/QlikView/Macro-readonly-multibox-field/m-p/1216558#M389587 <HTML><HEAD></HEAD><BODY><P><SPAN lang="en"><SPAN lang="en">can&nbsp; </SPAN>i do the operation described <SPAN>in this image</SPAN> <SPAN>through a macro</SPAN>?:</SPAN></P><P><SPAN lang="en"><BR /></SPAN></P><P><SPAN lang="en"><IMG alt="faq.png" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/153522_faq.png" style="height: 295px; width: 620px;" /><BR /></SPAN></P><P><SPAN lang="en"><BR /></SPAN></P><P><SPAN lang="en"><BR />i wont to <SPAN>set the</SPAN> properties <SPAN>of the object</SPAN> <SPAN>field</SPAN> <SPAN>of a</SPAN> "<SPAN>multi-box</SPAN>" "<SPAN>readonly</SPAN>"</SPAN></P></BODY></HTML> Fri, 17 Feb 2017 13:48:40 GMT 2017-02-17T13:48:40Z Macro - readonly multibox field https://community.qlik.com/t5/QlikView/Macro-readonly-multibox-field/m-p/1216558#M389587 <HTML><HEAD></HEAD><BODY><P><SPAN lang="en"><SPAN lang="en">can&nbsp; </SPAN>i do the operation described <SPAN>in this image</SPAN> <SPAN>through a macro</SPAN>?:</SPAN></P><P><SPAN lang="en"><BR /></SPAN></P><P><SPAN lang="en"><IMG alt="faq.png" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/153522_faq.png" style="height: 295px; width: 620px;" /><BR /></SPAN></P><P><SPAN lang="en"><BR /></SPAN></P><P><SPAN lang="en"><BR />i wont to <SPAN>set the</SPAN> properties <SPAN>of the object</SPAN> <SPAN>field</SPAN> <SPAN>of a</SPAN> "<SPAN>multi-box</SPAN>" "<SPAN>readonly</SPAN>"</SPAN></P></BODY></HTML> Fri, 17 Feb 2017 13:48:40 GMT https://community.qlik.com/t5/QlikView/Macro-readonly-multibox-field/m-p/1216558#M389587 2017-02-17T13:48:40Z Re: Macro - readonly multibox field https://community.qlik.com/t5/QlikView/Macro-readonly-multibox-field/m-p/1216559#M389588 <HTML><HEAD></HEAD><BODY><P>From the API Guide:</P><P></P><P>set mybox = ActiveDocument.GetSheetObject("MB01")</P><P>mbp = mybox.GetProperties</P><P>mbp.Layout.ReadOnly = true</P><P>mybox.SetProperties mbp</P></BODY></HTML> Fri, 17 Feb 2017 15:15:54 GMT https://community.qlik.com/t5/QlikView/Macro-readonly-multibox-field/m-p/1216559#M389588 m_woolf 2017-02-17T15:15:54Z Re: Macro - readonly multibox field https://community.qlik.com/t5/QlikView/Macro-readonly-multibox-field/m-p/1216560#M389589 <HTML><HEAD></HEAD><BODY><P>thx!</P><P></P><P>i want to apply this macro to only one field and not to all. </P><P></P><P>how can i do?</P></BODY></HTML> Fri, 17 Feb 2017 15:32:35 GMT https://community.qlik.com/t5/QlikView/Macro-readonly-multibox-field/m-p/1216560#M389589 2017-02-17T15:32:35Z Re: Macro - readonly multibox field https://community.qlik.com/t5/QlikView/Macro-readonly-multibox-field/m-p/1216561#M389590 <HTML><HEAD></HEAD><BODY><P>From the API Guide:</P><P>set mybox = ActiveDocument.ActiveSheet.CreateMultiBox</P><P>mybox.AddField "Class"</P><P>mybox.AddField "ClassComment"</P><P>mbp = mybox.GetProperties</P><P>mbp.MemberAttributes.Item(1).ReadOnly = true</P><P>mybox.SetProperties mbp</P></BODY></HTML> Fri, 17 Feb 2017 16:08:44 GMT https://community.qlik.com/t5/QlikView/Macro-readonly-multibox-field/m-p/1216561#M389590 m_woolf 2017-02-17T16:08:44Z