Initializing Option Buttons in Excel 2007
I have 2 option buttons on a worksheet. In Excel 2003, I initialized
them from the workbook_open event with the line:
sh.OLEObjects("EditorButton").Object.Value = 0
sh.OLEObjects("AuthorButton").Object.Value = 0
All other sheets in the workbook are hidden, except the one the
buttons are on.
After converting to Excel 2007, and converting the file to a .xlsm,
those lines give errors. I tried moving the lines to the
worksheet_activate event, but that doesn't seem to get executed when
the workbook opens.
I think they are forms buttons, but I'm not sure, and I don't know how
to tell.
|