+ Reply to Thread
Results 1 to 2 of 2

Move the Command Button Around

  1. #1
    Registered User
    Join Date
    04-13-2010
    Location
    Taiwan
    MS-Off Ver
    Excel 2007
    Posts
    25

    Move the Command Button Around

    Someone made me this macro to split a string of dates into different cells.

    However the actual document has thousands of rows, as i scroll down, the split butto stays at row 9.

    How can i make the button move down as i scroll down, or even make the button draggable so the button doesn't block the text.
    Attached Files Attached Files
    Last edited by bruce71101; 04-14-2010 at 02:07 AM.

  2. #2
    Forum Expert teylyn's Avatar
    Join Date
    10-28-2008
    Location
    New Zealand
    MS-Off Ver
    Excel 365 Insider Fast
    Posts
    11,372

    Re: Move the Command Button Around

    Without opening your workbook:

    Increase the row height of row 1 to accommodate the button. Move the button to row 1, then freeze panes at row 2

+ 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