| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Invalid Circles - Can I force their display?
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Printing Invalid Data Circles | Excel Programming | |||
| Force display to round down | Excel Programming | |||
| How to print the circles in formatting audit circle invalid data | Excel Worksheet Functions | |||
| Data Validation: Printing Invalid Data Circles | Excel Discussion (Misc queries) | |||
| How to force userform to display everything? | Excel Programming | |||
Linear Mode
