Changing Option Button Value
 

Thanks: I've been having trouble with Excel the last week
or so. One large file kept corrupting. I thought a
checkdisk had corrected the problems but I will try
reinstalling Excel
-----Original Message-----
Range("G1:G3").Value = False

worked fine for me. It cleared the option button that
was true.

--
Regards,
Tom Ogilvy

"Jan" wrote in message
...
I have selected 3 option buttons from the control
Toolbar
and linked each to a cell within the spread sheet.

When creating a macro to clear the active worksheet, I
want the selected option button to be cleared also. I
thought that by changing the linked cell value to false
that this would do it but that is not the case


.