This reply got me thinking of the solution. I save the current zoom level
for the screen in a variable, then change it to 100 while the shapes are
created. Once it's done, I reset the zoom level back to the original value.
The shapes then are placed exactly as required.
Thanks for your help
"Jon Peltier" wrote:
Because of issues like this, not just in 2007 but in all versions, some
people leave the window zoom at 100%.
- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______