Skip to main content
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)