Freeze Buttons

  • Thread starter Thread starter bw
  • Start date Start date
B

bw

I have selected "Freeze Panes" on some rows of my worksheet, but I have Macro
Buttons that fall outside of the frozen panes.

Is there a way to freeze my buttons so they will always be visible, even when I scroll?

Thanks,
Bernie
 
Yes,

Put them in a toolbar. Here's an example that adds them, to the Formatting
menu

Dim oCtl As CommandBarControl
With Application.CommandBars("Formatting")
Set oCtl = .Controls.Add(Type:=msoControlButton, temporary:=True)
With oCtl
.BeginGroup = True
.Caption = "myButton1"
.OnAction = "myMacro"
.FaceId = 27
End With
End With

I also suggest you check out John Walkenbach's site at
http://j-walk.com/ss/excel/tips/tip67.htm to help find the values of the
FaceIds, which will give you a decent toolbar button image.
 
As Tom and you indicated, "No way to do" (what I asked). But what you have
suggested here is interesting, and the link to John Walkenbach's site is very nice. I'll
have to study this to determine if it's what I want to do.

Good input!!

Thanks much,
Bernie
 
Back
Top