View Single Post
  #3   Report Post  
Don Guillett
 
Posts: n/a
Default

try this. It makes an oval so you can manipulate the cell ht & width
Sub docircle()
With ActiveCell
With ActiveSheet.Shapes.AddShape( _
msoShapeOval, .Left, .Top, .Width, .Height)
.Fill.Visible = msoFalse
.Line.Weight = 1
.Line.Visible = msoTrue
End With
End With
End Sub

--
Don Guillett
SalesAid Software

"BTaylor" wrote in message
...
Excel should let me circle a cell or number in a cell in the spreadsheet

for
display purposes.

Most of the time if you highlight a cell or number in a cell and you print
the spreadsheet on a black and white printer it becomes indiscreet or

blends
in with the rest of the numbers.

Allowing one to be able to circle would make it appear more user friendly

on
the printout and provide more options.