View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Gary''s Student Gary''s Student is offline
external usenet poster
 
Posts: 11,058
Default 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