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?
Participate now!
Don’t have an account yet? Register yourself now and be a part of our community!
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
Don’t have an account yet? Register yourself now and be a part of our community!