Command Button Question?

[Tom Schreiner]

Hi all...

In this example, I have a command button around cell K1...

If the user scrolls down, is there a way for the command button to follow without using "Freeze Frames"?

I want the command button to follow the scroll...

Thanks,
Tom

[Ivan F Moala]

On 2002-04-27 19:24, TsTom wrote:
Hi all...

In this example, I have a command button around cell K1...

If the user scrolls down, is there a way for the command button to follow without using "Freeze Frames"?

I want the command button to follow the scroll...

Thanks,
Tom

Tom
You couls try putting this code in the sheets
Events.
Assumes name of commandbutton is commanbutton1

Try and play around as required.

Private Sub Worksheet_SelectionChange(ByVal Target As Range)

Dim cmdbtn



Set cmdbtn = ActiveSheet.Shapes("CommandButton1")



cmdbtn.Top = Target.Top - cmdbtn.Height

cmdbtn.Left = Target.Left



End Sub

[Tom Schreiner]

Thanks again Ivan...
I should have been able to figure that one out?
Tom