View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Ken Ivins[_2_] Ken Ivins[_2_] is offline
external usenet poster
 
Posts: 5
Default 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