Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
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
Hi Vignesh S,
Go To--Sheet Properties
--Objects--select object which you want to change-----
----Properties
----Layout
---- In check( Movie/Size)