multipage - option buttons disappear from frame in Excel 2003
 

I have frame control with 2 option buttons on a multipage control; originally
developed in Excel 2002; after upgrading to 2003, the option buttons
disappear when the form is run. have tested this on several different
machines with same result and References are the same except for Office 10 vs
Office 11

no problems with any of the other controls on the pages/form.

how can this be fixed without transferring the controls over to a new form?
(which seems to work)

multipage - option buttons disappear from frame in Excel 2003
 

I've got the same problem, with more like 8 option buttons and images
that run macros! I developed mine in Office 2000. There is a similar
post which has been responded to further down the page. It mentions
something about code that protects the sheet may be tripping up.

multipage - option buttons disappear from frame in Excel 2003
 

Thanks, it's good to know that this isn't happening just to me.

I'm not sure if this is the same problem; my form is designed in the VBE and
has no relationship to any worksheets; it's weird because I can fix it by
inserting a new form and a new Multipage control and then copy and pasting
form the old form that is not working onto the new multipage control

"Hambone" wrote:

I've got the same problem, with more like 8 option buttons and images
that run macros! I developed mine in Office 2000. There is a similar
post which has been responded to further down the page. It mentions
something about code that protects the sheet may be tripping up.

multipage - option buttons disappear from frame in Excel 2003
 

problem resolved:

here is how i got the issue resolve. in my application, i had code that
positioned some checkboxes on various pages of the multipage control. for
some reason, after upgrading to 2003, the code also read the option buttons
as checkboxes - i.e. -
loop through all controls
if TypeOf ctl Is MsForms.CheckBox Then
set ctl.top = 100
end

for some reason, the code is also including option buttons thus:

loop through all controls
if TypeOf ctl Is MsForms.OptionButton Then
'do nothing
else if TypeOf ctl Is MsForms.CheckBox Then
set ctl.top = 100
end