Option Buttons Off When Program is opened
 

I have a worksheet with several option buttons. I would like to know how to
have all option buttons off (blank) when the worksheet is opened.

Vance

Option Buttons Off When Program is opened
 

In "ThisWorkbook"

Private Sub Workbook_Open()
Range("A1,A3,A5").clear
End Sub

set the range to the linked cells of the option buttons


Vance wrote:
I have a worksheet with several option buttons. I would like to know how to
have all option buttons off (blank) when the worksheet is opened.

Vance

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...mming/200707/1