How do I create a scroll list of macro buttons?

R

RobertM

I have created several buttons for different macros on one worksheet. How
can I make some type of scroll list that contains each macro button?
 
G

Gord Dibben

Place the buttons on a Toolbar which is activated when that worksheet is
activated.

Private Sub Worksheet_Activate()
Application.CommandBars("new bar name").Visible = True
End Sub

Private Sub Worksheet_Deactivate()
Application.CommandBars("new bar name").Visible = False
End Sub


Gord Dibben Excel MVP
 
Top