macro so no option button chosen

[Ken Ivins]

I have a form template I have designed that will be printed occasionally to
fill in manually. I created some option buttons for this form and want it to
open every time with neither option chosen. I assume that if someone plays
with this and saves it as a template then this feature may get messed with
(users can do the darndest things).

So I thought I would like a macro that would check each option button upon
opening and uncheck it. I have done a lot of macro work in Access but not
much in Excel. Any help would be greatly appreciated.

Thanks,
Ken Ivins

 

[Guest]

hi,
if you have done it in access then you have done it in
excel. just put the code in the workbooks on open event.

 

[Ken Ivins]

Well I tried

Private Sub Workbook_Open()
OptionButton59.Value = False
OptionButton60.Value = False
End Sub

But that did not work. It still opened with to Option 59 selected.

Ken