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!