Floating command button

mikerickson

MrExcel MVP

Joined

Jan 15, 2007

Messages

24,355

• Aug 5, 2009

• #2

I'm not sure about 2007, but before that version, you could create a custom Toolbar and put your button on it.

 

Upvote 0

N

newboss

New Member

Joined

Apr 28, 2009

Messages

43

• Aug 5, 2009

• #3

is it possible to do without tool bar ? with alone command button in2003

 

Upvote 0

mikerickson

MrExcel MVP

Joined

Jan 15, 2007

Messages

24,355

• Aug 5, 2009

• #4

One of the problems with this is that there is no OnScroll event.
Putting something like this in a sheet's event code might work for you.

Code:

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
    With ActiveWindow.VisibleRange
        ActiveSheet.Shapes("CommandButton1").Top = .Top
        ActiveSheet.Shapes("CommandButton1").Left = .Left
    End With
End Sub

 

Upvote 0

N

newboss

New Member

Joined

Apr 28, 2009

Messages

43

• Aug 6, 2009

• #5

thanks mikerickson
i was looking for the same ....

 

Upvote 0

S

Snowshoeken

Active Member

Joined

Aug 8, 2002

Messages

306

• Jul 15, 2010

• #6

Would this work for a Quad Arrow Callout? I attempted by replacing the CommandButton with Quad Arrow Callout 1, but no dice. Suggestions?

 

Last edited: Jul 15, 2010

Upvote 0

D

DaveVoss

New Member

Joined

Aug 31, 2012

Messages

1

Office Version

1. 365

Platform

1. Windows

• Aug 31, 2012

• #7

I found the simplest solution to be to create an extra row at the top of the worksheet and put command buttons there. Include that row in Freeze Panes and the buttons are always there. I know that's on the top, not bottom of the screen, but it works nicely.

 

Upvote 0