View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
[email protected] satlow@draper.com is offline
external usenet poster
 
Posts: 15
Default 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.