+ Reply to Thread
Results 1 to 4 of 4

multipage - option buttons disappear from frame in Excel 2003

  1. #1
    j b corner
    Guest

    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)


  2. #2
    Hambone
    Guest

    Re: 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.


  3. #3
    j b corner
    Guest

    Re: 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.
    >
    >


  4. #4
    j b corner
    Guest

    Re: 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


+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1