The suggested code make buttons move with mouse click to cell(s). But,
how can I make buttons move with scrollbar. It is like some graphics on
the web. When the user scroll down the page, the buttons move down as
well.

What methods or events I should use? Please give me some advices.

Thanks
Bon
Ken Johnson =E5=AF=AB=E9=81=93=EF=BC=9A

> Hi Bon,
>
> This is probably bad advice.....
>
> MyButton is from the forms toolbar, on Sheet1, and Excel named it
> "Button 1".
> The code is in the Sheet1 Module, is triggered when you change the
> selection and moves MyButton so that it is sitting just to the left of
> the new selection.
> Could get annoying though, and would have to be moved out of the way
> with a right click/drag to see the cell(s) it covers.
>
> Private Sub Worksheet_SelectionChange(ByVal Target As Range)
> Dim MyButton As Shape
> Set MyButton =3D Sheet1.Shapes("Button 1")
> With MyButton
> .Top =3D Target.Top
> .Left =3D Target.Left - .Width
> End With
> End Sub