+ Reply to Thread
Results 1 to 3 of 3

I have a button that runs a macro - I want to increase the size of the button

  1. #1
    Registered User
    Join Date
    01-08-2013
    Location
    New Zealand
    MS-Off Ver
    Excel 2003
    Posts
    2

    I have a button that runs a macro - I want to increase the size of the button

    Hi, I am an excel 2003 user - not a pro by any means, just know the basics to get done what I need to get done - most of the time.

    I think that it is a command button as this is the only reference I can find to it in the code. The code is much longer but doesn't appear to be referencing anything to do with the button format more the running of the macro after clicking it.

    Please Login or Register  to view this content.
    I just want to make the button bigger - it used to also have text on it but the button is now so tiny that you can only just click on it to run the macro. Any help or suggestions would be much appreciated.

    Thanks in advance.
    Last edited by jeffreybrown; 01-08-2013 at 07:56 PM. Reason: Please use code tags...Thanks.

  2. #2
    Forum Moderator - RIP Richard Buttrey's Avatar
    Join Date
    01-14-2008
    Location
    Stockton Heath, Cheshire, UK
    MS-Off Ver
    Office 365, Excel for Windows 2010 & Excel for Mac
    Posts
    29,464

    Re: I have a button that runs a macro - I want to increase the size of the button

    Hi, and welcome to the forum.

    Select the Design Mode option from the Excel menu then just select one of the button's handles and drag it to resize.
    Richard Buttrey

    RIP - d. 06/10/2022

    If any of the responses have helped then please consider rating them by clicking the small star icon below the post.

  3. #3
    Registered User
    Join Date
    01-08-2013
    Location
    New Zealand
    MS-Off Ver
    Excel 2003
    Posts
    2

    Re: I have a button that runs a macro - I want to increase the size of the button

    Thank you so much. I had been so close mucking around in Design Mode trying to select/edit the button.

    I have spent around 2 hours trying to Google search how to do this. It was made tricky by how small it was but using 400% zoom I was able to see the buttons handles in Design Mode.

    Thanks once again.

+ 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