Floating button

Good morning Excelski

Something like this should work, just be aware that you will lose your Undo functionality. There's no simple way around this so choose whether you want Undo or a floating Command Button.

Private Sub Worksheet_SelectionChange(ByVal Target As Excel.Range)
With Cells(Windows(1).ScrollRow, Windows(1).ScrollColumn)
' Change the value below to change where the button hovers on your screen
' Lower = further left, higher = further right
CommandButton1.Left = .Left + 100
End With
End Sub

HTH

DominicB