[Webinar] Learn how to a build a cloud-first strategyRegister Now


Import Button got larger

Posted on 2011-10-10
Medium Priority
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

ID: 36942203
can u attach the file here?

Expert Comment

ID: 36942531
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 31

Accepted Solution

gowflow earned 2000 total points
ID: 36943795
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

ID: 36943989
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

Fill in the form and get your FREE NFR key NOW!

Veeam is happy to provide a FREE NFR server license to certified engineers, trainers, and bloggers.  It allows for the non‑production use of Veeam Agent for Microsoft Windows. This license is valid for five workstations and two servers.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Microsoft has changed the look and feel of Azure AD and Microsoft account sign-in pages so that you will have a more unified look and feel when moving between the two interfaces.
In this post, I will showcase the steps for how to create groups in Office 365. Office 365 groups allow for ease of flexibility and collaboration between staff members.
This Micro Tutorial will demonstrate how to create pivot charts out of a data set. I also added a drop-down menu which allows to choose from different categories in the data set and the chart will automatically update.
Excel styles will make formatting consistent and let you apply and change formatting faster. In this tutorial, you'll learn how to use Excel's built-in styles, how to modify styles, and how to create your own. You'll also learn how to use your custo…

867 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