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

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.

-----Original Message-----
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


.

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



wrote in message
...
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.

-----Original Message-----
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


.