Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 35
Default Excel 97 keeps changing dimensions of autoshape rectangle

If i create an autoshape rectangle in a worksheet and when I try and set its
dimensions to 1.0 cm by 1.0 cm square, the app. changes this to 1.01cm by
1.01cm. Excel adds 0.01cm to every set of square dimensions I try and set.
However, I do not see this issue up to 1.0 cm i.e. if I set the dimensions of
the autoshape to 0.5 by 0.5 or 0.99 by 0.99 cm , these stay fixed. I have
tried everything that I know to try and resolve this .

Can anyone help with this ?
Thanks
--
surfing69
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel - xy plot fill plotted rectangle Mark Charts and Charting in Excel 4 September 15th 09 04:54 PM
How do i delete a saved rectangle in excel? gltrg1991 Excel Worksheet Functions 3 February 17th 09 01:50 PM
Changing Autoshape properties using formulas only Chris Excel Discussion (Misc queries) 0 September 7th 08 08:07 AM
Link from Autoshape keeps changing John Calder Links and Linking in Excel 2 September 3rd 07 11:30 PM
Inserting blanks or changing dimensions Jones Excel Worksheet Functions 1 June 6th 06 01:50 PM


All times are GMT +1. The time now is 04:52 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"