Skip to main content
Announcements
See what Drew Clarke has to say about the Qlik Talend Cloud launch! READ THE BLOG
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)