Putting our macros in pop down window on toolbar

[fishnfrogs]

Hi All...
In the older version of Excel, when I recorded or wrote a macro, there was an option to put in a popdown window on the toolbar.
In my Excel 2000 that option is gone.

So...is there an "easy" way to put macros in a popdown window on the toolbar? Reason I would like to do this is to make this easy to use for folks not familiar with Excel.
Then they just select the macro and it prints etc.

Cheers and thanks for all the help!

 

[taki]

Maybe this will help...

http://www.riverbank.co.uk/support/R1047.html

 

[Joe Was]

This is a selection system. The code could be attached to a Form Button added to the top of your Sheet, labled "Macros."

The code go's in a Standard Module.
You can modify the selections as needed.
Copy the code below to a Standard Module and test it, to see if you like it? Hope it helps. JSW

Sub MyMacros()
'Standard Module code!
'Display pick list box.
Dim Message, Title, Default, MyPick

'Set prompt.
'Add other macros to list with & Chr(13) & "# Macro Name"
Message = "Select the nember of the macro you want to run:" & Chr(13) & Chr(13) & _
"1 Select No Macro!" & Chr(13) & "2 Select Test Macro Message."
'Set title.
Title = "Select a Macro to run!"
'Set default.
Default = "1"

'Display message, title, and default value.
MyPick = InputBox(Message, Title, Default)
'Optional, controle box position!
'Display dialog box at position 100, 100.
'MyPick = InputBox(Message, Title, Default, 100, 100)

Select Case MyPick
Case 1
MsgBox "No Macro Selected!"

'Add additional Case code as needed!
Case 2
MyTest

Case Else
MsgBox "No Active Macro Selected!"

End Select
End Sub

Sub MyTest()
MsgBox "This is a Test!"
End Sub

 

[fishnfrogs]

Thanks you! You all are great.
Cheers,
Suzanne