Lines means borders? If so, Format-->Conditional formatting. Shapes? That
would have to be done with code.
************
Anne Troy www.OfficeArticles.com
Well I am trying to draw some shapes using lines basically from the draw
tool. I want to be able to change certain lines and make them appear or
dissapear or change place when a certain cell has a certain value in it. Is
that something that needs coding? IF yes where can I learn? I haven't used VB
before. Thank you.