I have a button that when you click it it inserts a line via the below code:
Sub test()
ActiveSheet.Shapes.AddLine(100, 300#, 300, 300).Select
End Sub
How can I tell it to draw the line in a specific cell (AM13, P15,ect.). Also I would like it to turn the font of any data in the cells that ar lined out white.
Is it also possible that upon another click it will remove the line and return the font to black.
Any help would be great,
Thanks
Sub test()
ActiveSheet.Shapes.AddLine(100, 300#, 300, 300).Select
End Sub
How can I tell it to draw the line in a specific cell (AM13, P15,ect.). Also I would like it to turn the font of any data in the cells that ar lined out white.
Is it also possible that upon another click it will remove the line and return the font to black.
Any help would be great,
Thanks