Hi,

Am Wed, 18 Sep 2013 08:02:43 -0700 (PDT) schrieb :

I want to be able to scroll the worksheet but have the button stay at the same position on the screen.

freeze the window below your button.
Or try worksheet event:

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
CommandButton1.Top = ActiveWindow.ScrollRow * 15
End Sub

The 15 you have to suit to your monitor. If you sroll and select a cell,
the button goes down or up.


Regards
Claus B.
--
Win XP PRof SP2 / Vista Ultimate SP2
Office 2003 SP2 /2007 Ultimate SP2