Is it possible to have a button float, and move as the sheet scrolls
down or up?

I use a long sheet and use a button with a macro and would like it
close to the cursor.

THNX

I'm not aware of a way to do this (although there might be one). If the
button's not too big, you could just put somewhere on Row 1 and freeze Row 1
so the button stays visible. James
"Luis A. Vázquez" wrote in message
ups.com...
Is it possible to have a button float, and move as the sheet scrolls
down or up?

I use a long sheet and use a button with a macro and would like it
close to the cursor.

THNX

Well, this seems to work. Note that it changes the button location when you
change the selected cell, not when you scroll. I used a button from the
Forms toolbar. Not tested on a button from the Control toolbar. This goes
in the worksheet module (click on worksheet's tab, select View code, paste
code in there). HTH, James

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
ActiveSheet.Buttons(1).Top = ActiveCell.Top
End Sub

"Zone" wrote in message
...
I'm not aware of a way to do this (although there might be one). If the
button's not too big, you could just put somewhere on Row 1 and freeze Row
1 so the button stays visible. James
"Luis A. Vázquez" wrote in message
ups.com...
Is it possible to have a button float, and move as the sheet scrolls
down or up?

I use a long sheet and use a button with a macro and would like it
close to the cursor.

THNX

that should be RIGHT-click on worksheet's tab

"Zone" wrote in message
...
Well, this seems to work. Note that it changes the button location when
you change the selected cell, not when you scroll. I used a button from
the Forms toolbar. Not tested on a button from the Control toolbar. This
goes in the worksheet module (click on worksheet's tab, select View code,
paste code in there). HTH, James

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
ActiveSheet.Buttons(1).Top = ActiveCell.Top
End Sub

"Zone" wrote in message
...
I'm not aware of a way to do this (although there might be one). If the
button's not too big, you could just put somewhere on Row 1 and freeze
Row 1 so the button stays visible. James
"Luis A. Vázquez" wrote in message
ups.com...
Is it possible to have a button float, and move as the sheet scrolls
down or up?

I use a long sheet and use a button with a macro and would like it
close to the cursor.

THNX

On Oct 17, 1:33 pm, "Zone" wrote:
I'm not aware of a way to do this (although there might be one). If the
button's not too big, you could just put somewhere on Row 1 and freeze Row 1
so the button stays visible. James
"Luis A. Vázquez" wrote in oglegroups.com...

Is it possible to have a button float, and move as the sheet scrolls
down or up?

I use a long sheet and use a button with a macro and would like it
close to the cursor.

THNX

True. Actualy thats what i did, still wanted to verify if the floating
part was possible.

thnx ZONE

On Oct 17, 3:49 pm, Luis A. Vázquez wrote:
On Oct 17, 1:33 pm, "Zone" wrote:

I'm not aware of a way to do this (although there might be one). If the
button's not too big, you could just put somewhere on Row 1 and freeze Row 1
so the button stays visible. James
"Luis A. Vázquez" wrote in oglegroups.com...

Is it possible to have a button float, and move as the sheet scrolls
down or up?

I use a long sheet and use a button with a macro and would like it
close to the cursor.

THNX

True. Actualy thats what i did, still wanted to verify if the floating
part was possible.

thnx ZONE

ZONE....Tried it and works fine. It will serve the purpose. Thnx

You're welcome, Luis. Thanks for the feedback. James
"Luis A. Vázquez" wrote in message
ps.com...
On Oct 17, 3:49 pm, Luis A. Vázquez wrote:
On Oct 17, 1:33 pm, "Zone" wrote:

I'm not aware of a way to do this (although there might be one). If the
button's not too big, you could just put somewhere on Row 1 and freeze
Row 1
so the button stays visible. James
"Luis A. Vázquez" wrote in
oglegroups.com...

Is it possible to have a button float, and move as the sheet scrolls
down or up?

I use a long sheet and use a button with a macro and would like it
close to the cursor.

THNX

True. Actualy thats what i did, still wanted to verify if the floating
part was possible.

thnx ZONE

ZONE....Tried it and works fine. It will serve the purpose. Thnx

I have been looking for a similar solution, but I have several buttons along
the left-hand side of the sheet (an alphabetical letter index that filters
the sheet).

I have headers in the first row and have frozen the top row for scrolling
purposes (obviously all 26 of my buttons would not fit into the scheme
described by Zone below).

Is there no way to create free-floating buttons independent of any scrolling
within the sheet? It seems like this functionality should be available, but I
can't figure it out.

Any assistance would be greatly appreciated. Thanks.




"Zone" wrote:

I'm not aware of a way to do this (although there might be one). If the
button's not too big, you could just put somewhere on Row 1 and freeze Row 1
so the button stays visible. James
"Luis A. Vázquez" wrote in message
ups.com...
Is it possible to have a button float, and move as the sheet scrolls
down or up?

I use a long sheet and use a button with a macro and would like it
close to the cursor.

THNX