Results 1 to 5 of 5
  1. #1
    3 Star Lounger
    Join Date
    Aug 2002
    Location
    St. Charles, Illinois
    Posts
    222
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Command button (Excel 2003)

    Why does the command button size change upon use or repetitive clicking? The command button is connected to a macro.

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Command button (Excel 2003)

    <img src=/S/scratch.gif border=0 alt=scratch width=25 height=29> It shouldn't, unless the macro associated with the button contains code to do so.

  3. #3
    Silver Lounger
    Join Date
    Mar 2001
    Location
    Dallas, Texas, USA
    Posts
    1,680
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Command button (Excel 2003)

    Never seen this happen. Just to be certain that the button properties are not being accidently changed through right-clicking, re-sizing, do this: Right-click on the button, choose Format Properties from the dialog and then tick the slection shown in the picture below. This should help the button keep it's dimensions and not be changed by accident...
    - Ricky

  4. #4
    New Lounger
    Join Date
    Jun 2004
    Location
    Itasca, Illinois, USA
    Posts
    23
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Command button (Excel 2003)

    Could the issue be related in some way to the screen resolution settings? (I was ghostwriter for original post) The issue appears in two forms - the command button macro is purely navigational and toggles between different sheets in the workbook - when clicking back and forth, either the button grows larger or the font in the command button name shrinks. The font size setting remains the same but the appearance changes.

  5. #5
    5 Star Lounger jujuraf's Avatar
    Join Date
    Jun 2001
    Location
    San Jose, California, USA
    Posts
    1,061
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Command button (Excel 2003)

    Yes I have seen this same error! You are not going <img src=/S/nuts.gif border=0 alt=nuts width=15 height=15>!! It is indeed a resolution thingy and I 'fixed' it by resizing the button a bit (manually dragging the side handles to stretch it just a tad). I saw it where the text on the button either got really small or really big. Once I adjusted its size just a tad, the text always stayed the set size.

    Deb

Posting Permissions

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