View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
joel joel is offline
external usenet poster
 
Posts: 9,101
Default Macro for moving arrow shapes

You need two lines. One always fixed that is verticle and one that rotates
with the arrow.

"Yajiv" wrote:

I have an arrow shape pointing upwards. I want to move it's head with
the other end fixed. Just like a speedometer.If I use shapes
(0).rotation(45), i get the rotation, but it adjusts the whole arrow.
not the head.
Is there any way? Any help would be appreciated.