Import Button got larger

Posted on 2011-10-10
Last Modified: 2012-05-12
gowflow: The Import button, for some very odd reason, just started getting bigger when I clicked on it. At one point getting so big it took up a large portion of the sheet. I closed down excel and started up and it didn't get any bigger but needs to be reduced in size. import button
Question by:JaseSt
    LVL 12

    Expert Comment

    can u attach the file here?
    LVL 4

    Expert Comment

    Are you able to go to the developer tab, click on developer mode button, and right click to select the button as an object? If you can do that, you should be able to resize it.
    LVL 29

    Accepted Solution

    Run your file accept macros then go to developper and click on Design then click on the red button and resize it. after that right click on the button and click on property and make sure it is like the attached pic. Make sure especially that autosize = false and Locked = true and wordwrap = true.

    Author Closing Comment

    The settings on the button were already as you have indicated above, gowflow, but now I know what they should be and how to adjust if necessary. Thanks. An easy one for you at last. :)

    Featured Post

    Threat Intelligence Starter Resources

    Integrating threat intelligence can be challenging, and not all companies are ready. These resources can help you build awareness and prepare for defense.

    Join & Write a Comment

    Entering a date in Microsoft Access can be tricky. A typo can cause month and day to be shuffled, entering the day only causes an error, as does entering, say, day 31 in June. This article shows how an inputmask supported by code can help the user a…
    Recently Microsoft released a brand new function called CONCAT. It's supposed to replace its predecessor CONCATENATE. But how does it work? And what's new? In this article, we take a closer look at all of this - we even included an exercise file for…
    The viewer will learn how to  create a slide that will launch other presentations in Microsoft PowerPoint. In the finished slide, each item launches a new PowerPoint presentation and when each is finished it automatically comes back to this slide: …
    This Micro Tutorial will demonstrate in Google Sheets how to use the HYPERLINK function to create live links inside your spreadsheet.

    728 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    18 Experts available now in Live!

    Get 1:1 Help Now