View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
Curtis Curtis is offline
external usenet poster
 
Posts: 181
Default Size of Shapes changes when the Zoom level changes

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
_______