+ Reply to Thread
Results 1 to 3 of 3

any tips on BUTTONS

  1. #1
    Registered User
    Join Date
    12-16-2010
    Location
    San Antonio, TX, USA
    MS-Off Ver
    Excel 2007
    Posts
    11

    any tips on BUTTONS

    I use BUTTONS (Form Control) in xl07 to trigger macros.

    It is easy to adjust their size and other properties, but I am
    looking for a better way to precisely place them on the sheet
    to give an aligned clean look.

    Any tips on moving/placing BUTTONS ??
    Last edited by SAElmer; 01-28-2011 at 01:27 PM.

  2. #2
    Forum Expert Cutter's Avatar
    Join Date
    05-24-2004
    Location
    Ontario,Canada
    MS-Off Ver
    Excel 2010
    Posts
    6,451

    Re: any tips on BUTTONS

    One handy one is this:
    When you place the button on your sheet you can 'snap' the corners to grid lines.
    Position your button with its top left corner below and to right of intended final location.
    Click on top left drag handle of the button and drag it toward top left corner of target cell.
    Hit the Alt key and top left corner of button 'snaps' to top left corner of cell.
    Release mouse button.
    Repeat this with lower right drag handle and lower right corner of target cell.

    This will give you a button which is the size of the cell it is over. If you then set the property of the button to "move and size with cell" you can control the size of it by changing the size of the row/column.

    Doing this with a series of buttons will have them perfectly aligned and equally sized.


    One more thing about moving them: with the button selected you can incrementally move it using the arrow keys. Setting the zoom level to a high number (like 400%) while doing this will allow you to see your alignments better (if you're not using the first tip about snapping to the grid).
    If you select more than one button (by holding down shift key while selecting others) you can move them simultaneously with the arrow keys.
    Last edited by Cutter; 01-28-2011 at 11:40 AM.

  3. #3
    Registered User
    Join Date
    12-16-2010
    Location
    San Antonio, TX, USA
    MS-Off Ver
    Excel 2007
    Posts
    11

    Re: any tips on BUTTONS

    Perfect, see, I knew there had to be some tricks! Thanks very much!

+ 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