Buttons and their position in the spreadsheet

    Is it possible to have a button float the same way a toolbar will, so that when you scroll across or down the button comes with you?

    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

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!

Register Yourself Login