Buttons and their position in the spreadsheet

  • Create a new Workbook


    Add a CommandButton with ControlToolBox
    ToolBar (CommandButton1)


    Right Click on Sheet Tab


    Paste this code


    Private Sub Worksheet_SelectionChange(ByVal Target As Excel.Range)
    CommandButton1.Top = ActiveCell.Top
    CommandButton1.Left = ActiveCell.Offset(0, 1).Left
    End Sub



    Return to Excel Worksheet and scroll around the screen and the button will follow.


    This is very crude and will get error if you go to column IV but should satisfy your query