Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Erase Drawing Object
In a given range, say B1 to AX33, randomly there are
line draw objects. Obviously, highlite such cell to individually delete one line or object at a time How would you delete all the objects in a range. With Thanks |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Erase Drawing Object
Not sure exactly what you are looking for but try these ideas
Sub DeleteSheetDrawingObjects() ActiveSheet.DrawingObjects.Delete ActiveWorkbook.Save End Sub Sub noborders() Worksheets("Sheet1").Range("A1:D4") _ .Borders.LineStyle = xlNone End Sub -- Don Guillett Microsoft MVP Excel SalesAid Software "smandula" wrote in message oups.com... In a given range, say B1 to AX33, randomly there are line draw objects. Obviously, highlite such cell to individually delete one line or object at a time How would you delete all the objects in a range. With Thanks |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Erase Drawing Object
Thanks Don Guillett
Your solution worked great |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Erase Drawing Object
Glad to help
-- Don Guillett Microsoft MVP Excel SalesAid Software "smandula" wrote in message ps.com... Thanks Don Guillett Your solution worked great |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Floating Drawing Object | Excel Programming | |||
Drawing Object in a Userform | Excel Programming | |||
The drawing tools in MS office should include an erase tool bar | Excel Worksheet Functions | |||
Drawing Object | Excel Programming | |||
How to draw a object and erase it programmatically | Excel Programming |