Excel 2000 ... I have a spread sheet created by a co-
worker which contains (perhaps 60) AutoShapes. The
AutoShape's Properties - Object Positioning is set
to "Move & Size with Cells" ... I wish this to be "Do Not
Move or Size with Cells".

Above said ... is there a way to globally accomplish this
for all 60 AutoShapes or must each AutoShape be selected &
set independently?

Please tell me there is a global way ... Thanks ... Kha

If you press Ctrl and Shift you can then click on each one and add it to the
selection, then you will only have to change the properties once (although
the clicking may be a bit time consuming it should still be quicker)

"Ken" wrote:

Excel 2000 ... I have a spread sheet created by a co-
worker which contains (perhaps 60) AutoShapes. The
AutoShape's Properties - Object Positioning is set
to "Move & Size with Cells" ... I wish this to be "Do Not
Move or Size with Cells".

Above said ... is there a way to globally accomplish this
for all 60 AutoShapes or must each AutoShape be selected &
set independently?

Please tell me there is a global way ... Thanks ... Kha

There's an arrow icon on the Drawing toolbar that'll let you lasso as many
shapes as you can see, too.

Shrink the zoom to as small as possible and maybe get lots more!

cdb wrote:

If you press Ctrl and Shift you can then click on each one and add it to the
selection, then you will only have to change the properties once (although
the clicking may be a bit time consuming it should still be quicker)

"Ken" wrote:

Excel 2000 ... I have a spread sheet created by a co-
worker which contains (perhaps 60) AutoShapes. The
AutoShape's Properties - Object Positioning is set
to "Move & Size with Cells" ... I wish this to be "Do Not
Move or Size with Cells".

Above said ... is there a way to globally accomplish this
for all 60 AutoShapes or must each AutoShape be selected &
set independently?

Please tell me there is a global way ... Thanks ... Kha


--

Dave Peterson