Invalid Circles - Can I force their display?
Try:
Sub circleIt()
ActiveSheet.CircleInvalid
End Sub
--
Gary''s Student - gsnu200909
"Dreiding" wrote:
Excel 2003, I'm doing some data comparison via macros and would like to flag
problem cells using the validation circles. Previously I used cell shading
for highlighting, but this would remove user shading.
Can I select a cell and place a Invalid Circle around it?
Is this possible? Suggestions appreciated.
- Pat
|