Initializing Option Buttons in Excel 2007

[satlow]

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.

 

[Jim Rech]

Well if they are Forms toolbar option buttons you can set them like this in
either Excel 2003 or 2007:

sh.OptionButtons("Option Button 1").Value = True

where sh is set to a worksheet.

 

[satlow]

Thanks, Jim. That didn't work, but once I removed the optionbuttons
from the group they were in, the original syntax worked. I think
sh.optionbuttons is no longer valid in Excel 2007.
Felsa