Hi,

My company is switching over to XL2007 and I have some problems with how
2007 is handling shapes in a workbook I have created.

with shp
.top = .topleftcell.top+2
.left = .topleftcell.left+2
end with

in excel 2003 this works great for the worksheet
in excel 2007, for some reason, after this runs, the .topleftcell is now
actually the cell one row up and one column left of what started as the
..topleftcell.

Is this a bug in XL2007, or is there a change to the .top and .left
properties for shapes and ranges that could be causing this? Any workaround?

Another potentially related issue I've got is that whenever I open this or
another related workbook in XL2007, shapes (.jpgs and embedded excel charts)
that are not touched by macros are moving around - changing places or size on
a protected worksheet. If I close (not saving changes) and reopen,
everything may be fine, or something else may have moved/grown/shrank.

Any ideas? I'm opening and saving the files in Xl2003 compatibility mode,
as I'm one of the earlier people to switch over to 2007, but everyone is
doing so in the next while.