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?

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



On Mon, 31 Oct 2005 13:15:04 -0800, "RobertM"
wrote:

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?