![]() |
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 |
All times are GMT +1. The time now is 04:08 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com