+ Reply to Thread
Results 1 to 2 of 2

Option Button on sheet changes size in 1024 by 768 resolution

  1. #1
    Michael Tress
    Guest

    Option Button on sheet changes size in 1024 by 768 resolution

    We have built a spread sheet that used option buttons to control selections,
    within groups. The resolution used during the construction of the spread
    sheet was 1280 by 1024. However, for display purposes we are constrained to
    1024 by 768. Within this resolution the option button when selected grows
    larger. And when selected repeatedly they grow larger still. There seems to
    be a limit, but it is not reached until a option button completely obscures
    its neighboring button and any text that may be near by.

    During our meeting this morning we were bogged down by this poor display
    issue. We would like to have the buttons remain the same size. We were not
    in design mode when we were selecting the buttons.

    The option buttons are not on any forms and just float above the
    spreadsheet. They control a "Y" value being entered in the selected cell and
    "" being placed in all other cells within the group.

    Thank you in advance,
    Michael

  2. #2

    Re: Option Button on sheet changes size in 1024 by 768 resolution

    Hello Michael:

    I have experienced this exact problem since acquiring a new computer
    with Excel 2003 in January of this year, and it is a very serious
    problem. It affects other controls (option buttons, checkboxes, etc.)
    as well as the command button. If you use a button from the Forms
    Toolbar, you will not have this problem. However, the functionality
    and feature-set available to you is not as extensive with a Forms
    button. It can activate a macro, though, and this might be all you
    want to do. One problem with the button from the Forms toolbar is that
    it doesn't give a good "snap action" when clicked (at least not on my
    high-end laptop which is running Excel 2003).

    This "controls" problem (changing size, wild behavior of fonts) has -
    in my opinion - essentially disabled the use of ActiveX controls in
    Excel, which I think should be regarded as a MAJOR, MAJOR problem
    worthy of no-holds-barred attention of Microsoft. I know 5 other
    people with the same problem, and all have different machines with MS
    Office acquired independantly. It is related to the screen resolution
    issue. If you create an application with 1024x768 setting - and if you
    never change it - I believe things work fine. But the world is moving
    to widescreen laptops, and users want their screens set to the wide
    format. But doing so with Excel will cripple advanced programs using
    ActiveX controls.

    If you should learn of a fix - tomorrow or next year - would you kindly
    let me in on it!

    Regards

    David


+ 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