Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
vignesh_s
Creator
Creator

Object Move/size proporties

Hi all,

I have 150 objects in my dashboard, i have disabled the Move/size proporties in "Sheet Proporties" so that it ll apply to all the object in application,now i need only one object  should be resized ,if i enable Move/size proporties it will applicable to all but i dont want to happen like that, is there any short cut to achive in small steps, otherwise i should do manually to all the 120 objects

3 Replies
m_woolf
Master II
Master II

This macro should set allow move/size to false for all objects on the active sheet:

set sh = ActiveDocument.ActiveSheet

for i = 0 to sh.NoOfSheetObjects-1

     set obj = sh.SheetObjects(i)

     mbp = obj.GetProperties

     mbp.Layout.Frame.AllowMoveSize = false

     obj.SetProperties mbp

    obj.SetFrameDef fr

next

vignesh_s
Creator
Creator
Author

hi thanks for the replay , my requirment is,out of 120 object only one object should b able to resize the rest should b disable the move r size proporties

ramcena306
Creator II
Creator II

Hi Vignesh S,

Go To--Sheet Properties

                 --Objects--select object which you want to change-----

               ----Properties

              ----Layout

             ---- In check( Movie/Size)