CF to grey out the two unused options
Jock wrote:
Hi Glenn,
these work fine however, I have changed the functionality of the sheet so
that, rather than enter a date in Y:AA, the user will double click the cell
and a 'tick ("P" formatted as wingdings2) will appear.
Because this is done by code, the CF formula doesn't work (I presume).
Is there a way around this?
Thanks
Try COUNTA().
|