topic Lock a variable in QlikView https://community.qlik.com/t5/QlikView/Lock-a-variable/m-p/222842#M75420 <HTML><HEAD></HEAD><BODY><P>I need to know how to execute a macro to lock a variable</P><P>I have this but it only works in one sheets, when I change of sheet the lock function stop to works</P><P>Sub Lock<BR />Set q = ActiveDocument<BR />q.LockAll<BR />end sub</P></BODY></HTML> Thu, 22 Apr 2010 23:51:26 GMT 2010-04-22T23:51:26Z Lock a variable https://community.qlik.com/t5/QlikView/Lock-a-variable/m-p/222842#M75420 <HTML><HEAD></HEAD><BODY><P>I need to know how to execute a macro to lock a variable</P><P>I have this but it only works in one sheets, when I change of sheet the lock function stop to works</P><P>Sub Lock<BR />Set q = ActiveDocument<BR />q.LockAll<BR />end sub</P></BODY></HTML> Thu, 22 Apr 2010 23:51:26 GMT https://community.qlik.com/t5/QlikView/Lock-a-variable/m-p/222842#M75420 2010-04-22T23:51:26Z Lock a variable https://community.qlik.com/t5/QlikView/Lock-a-variable/m-p/222843#M75421 <HTML><HEAD></HEAD><BODY><P>Call the same sub using the OnActivateSheet macro trigger.</P></BODY></HTML> Fri, 23 Apr 2010 06:30:05 GMT https://community.qlik.com/t5/QlikView/Lock-a-variable/m-p/222843#M75421 vupen 2010-04-23T06:30:05Z