|
How to make straight line after edit points
Hi,
In excel after we draw line then edit the point at the center we will get 2 different line with angle. Now I wanted to create macro when we click this line and run this macro will make the line one horizontally straight and another line vertically straight. Pls help how to create this macro http://xlsblog.com |
How to make straight line after edit points
Why not just add an elbow connector instead of a line?
ActiveSheet.Shapes.AddConnector(msoConnectorElbow, 10, 10, 250, 250).Adjustments.Item(1) = 1 'or use 0 HTH, Bernie MS Excel MVP "geniusideas" wrote in message ... Hi, In excel after we draw line then edit the point at the center we will get 2 different line with angle. Now I wanted to create macro when we click this line and run this macro will make the line one horizontally straight and another line vertically straight. Pls help how to create this macro http://xlsblog.com |
| All times are GMT +1. The time now is 04:08 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com