macro so no option button chosen
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.
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.
Any help would be greatly appreciated.
Thanks,
Ken Ivins
|