Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Greetings!
I have the following macro which adds a line to an existing oval shape. The macro works fine, except the shape is still selected when the macro finishes. I've tried inserting "ActiveSheet.Shapes("Oval 1").Deselect" at the end of the code, but I get a "runtime error 438." Is there a way I can get the macro to leave the shape in unselected mode when it finishes? Thanks, Jeff Sub addborder1() ActiveSheet.Shapes("Oval 1").Select Selection.ShapeRange.Line.Weight = 8# Selection.ShapeRange.Line.DashStyle = msoLineSolid Selection.ShapeRange.Line.Style = msoLineSingle Selection.ShapeRange.Line.Transparency = 0# Selection.ShapeRange.Line.Visible = msoTrue Selection.ShapeRange.Line.ForeColor.SchemeColor = 8 Selection.ShapeRange.Line.BackColor.RGB = RGB(255, 255, 255) End Sub |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Shape Outline (border) | Excel Discussion (Misc queries) | |||
my curser changed from arrow shape to a cross shape???? | New Users to Excel | |||
ActiveChart.Deselect won't Deselect | Charts and Charting in Excel | |||
Deleting a shape and the cell contents the shape is in. | Excel Programming | |||
Deleting a shape and the cell contents the shape is in. | Excel Programming |