View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
Andy Pope Andy Pope is offline
external usenet poster
 
Posts: 2,489
Default Edit shape with snap to grid on only allows movement down andrigh

Hi,

Looks like this might be a bug.
I thought a possible work around would be to turn of the Snap to grid
and use the ALT key to align to cell border. Whilst this allows you to
drag the point in any direction when you press ALT the point jumps
straight back to it's starting position.

Cheers
Andy

reb197 wrote:
To reproduce this problem:

Switch on Align-Snap to Grid.
Draw a rectangle in the middle of the sheet.
Edit Shape-Convert to freeform
Edit Shape-Edit Points

Try dragging the top left point around - you can move it to the right and
below its original position but not above or to the left of it.

Adding an additional point completely throws it. The additional point snaps
to a mysterious grid all of its own!

Anyone have a workaround / fix for this?




--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info