Chart/Shape Objects: De-Link From Column Widths?
 

When I create Chart objects from VBA, I'm using (X,Y) coordinates to place them.

But after they're all created/placed and the dust has settled, if the user
re-sizes a column any charts that are laying over that column get their widths
changed by the amount of the column width change. Ditto row height changes.

Is there any way for me to de-link the Chart objects from the row and column
dimensions - so that they just float there and are unaffected by changes to
same?
--
PeteCresswell

Chart/Shape Objects: De-Link From Column Widths?
 

Per (PeteCresswell):
Is there any way for me to de-link the Chart objects from the row and column
dimensions - so that they just float there and are unaffected by changes to
same?

Oops!

Got it: .Placement = xlFreeFloating
--
PeteCresswell

Chart/Shape Objects: De-Link From Column Widths?
 

Oops!

Ha ha, the Send button works miracles, eh?

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
http://PeltierTech.com
_______


"(PeteCresswell)" wrote in message
...
Per (PeteCresswell):
Is there any way for me to de-link the Chart objects from the row and
column
dimensions - so that they just float there and are unaffected by changes
to
same?

Oops!

Got it: .Placement = xlFreeFloating
--
PeteCresswell

Chart/Shape Objects: De-Link From Column Widths?
 

Per Jon Peltier:
Oops!

Ha ha, the Send button works miracles, eh?


Once I worked with a lady that maintained that every keyboard should have an "Oh
****!" key. You press it and it automagically recalls the last thing your sent
out.
--
PeteCresswell

Chart/Shape Objects: De-Link From Column Widths?
 

(PeteCresswell) wrote:
Per Jon Peltier:
Oops!
Ha ha, the Send button works miracles, eh?


Once I worked with a lady that maintained that every keyboard should have an "Oh
****!" key. You press it and it automagically recalls the last thing your sent
out.


Obviously she went on to help design Microsoft Exchange.

Those of us who use *real* email get to laugh twice when that happens.




Bob
--