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 | |||
Check box - true/false - i'd like a third option n/a | Excel Discussion (Misc queries) | |||
Assign different macros for True/False button | Excel Discussion (Misc queries) | |||
TRUE/FALSE MACRO using Option Buttons | Excel Discussion (Misc queries) | |||
keep source formatting is not an option in paste option button | Excel Discussion (Misc queries) | |||
New button does not open the template workbook set up | Excel Discussion (Misc queries) |