LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
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.

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Option Buttons, Forms Control, Excel 2007 - 3 options Paula Excel Worksheet Functions 6 February 6th 09 07:36 PM
option buttons in excel GKinSC New Users to Excel 1 January 13th 09 02:56 AM
Excel Option buttons AMS Excel Discussion (Misc queries) 3 May 16th 07 08:11 PM
Excel option buttons Tosty Excel Discussion (Misc queries) 2 February 12th 05 04:13 PM
Excel and option buttons Paul Excel Programming 3 September 25th 03 07:04 PM


All times are GMT +1. The time now is 01:09 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"