Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Formula to point to another cell if an option is chosen. | Excel Worksheet Functions | |||
macro so no option button chosen | Excel Programming | |||
macro so no option button chosen | Excel Programming | |||
validate an option is chosen | Excel Programming | |||
User Option to save to chosen destination | Excel Programming |