+ Reply to Thread
Results 1 to 3 of 3

Buttons shrinking for no reason

  1. #1
    Forum Contributor
    Join Date
    06-28-2004
    MS-Off Ver
    Home/Office 2016
    Posts
    246

    Buttons shrinking for no reason

    I created several buttons on a spreadsheet, and they work 99.99999% of the time.
    But every once in awhile, they will shrink and I can't 'undo' that change - and have to go to the latest backup version.

    * I can't control when it happens, so I don't have an example of when it does, but I did attach a screen shot of before and after.

    1) the buttons are set to 'move but don't resize'
    2) I need the buttons to move to enter individual scores - and that works fine. So, I CAN'T set them to "Don't move or size"

    Any ideas why/how this is happening? * btw- the buttons still work after they shrink....but I can't get them back to normal without using a backup.
    Attached Images Attached Images
    Last edited by x65140; 03-31-2015 at 08:05 AM.

  2. #2
    Forum Expert
    Join Date
    01-23-2013
    Location
    USA
    MS-Off Ver
    Microsoft 365 aka Office 365
    Posts
    3,863

    Re: Buttons shrinking for no reason

    Hi x65140,

    My speculation is that the buttons are 'Active X' Command Buttons. 'Active X' controls are known for their unpredictable behavior. If this is the problem, two ways to solve the problem are:
    a. Replace the 'Active X' Command Buttons with 'Forms' Command Buttons which are more stable.
    b. Keep the 'Active X' Command Buttons. Rename the Command Buttons to known names. Determine the location of each of the Command Buttons when the Sheet is acting normally. Create a Macro to restore the Command Buttons to their original splendor, whenever the Command Buttons misbehave.

    If you need additional help, please upload a sample workbook that contains the Command Buttons in question.

    Lewis

  3. #3
    Forum Contributor
    Join Date
    06-28-2004
    MS-Off Ver
    Home/Office 2016
    Posts
    246

    Re: Buttons shrinking for no reason

    Appreciate the response. I'll check it out....thanks.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Shrinking text on Excel 2007 command buttons, labels and textboxes
    By csipke in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 11-25-2012, 09:57 PM
  2. Shrinking Buttons
    By JimBobBowie in forum Excel General
    Replies: 8
    Last Post: 07-12-2011, 08:12 AM
  3. automatically shrinking buttons
    By Hein in forum Excel General
    Replies: 9
    Last Post: 08-05-2009, 09:00 AM
  4. Shrinking Combo Box
    By yankeesx23 in forum Excel General
    Replies: 1
    Last Post: 10-09-2008, 11:23 AM
  5. Text in Buttons is shrinking with each Click. HELP!!!
    By Baxter in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-22-2005, 03:26 PM

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