Freeze Buttons

[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

 

[Bob Phillips]

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.

 

[Tom Ogilvy]

no setting that would do that.

Regards,
Tom Ogilvy

 

[bw]

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