Putting our macros in pop down window on toolbar

fishnfrogs

New Member
Joined
Oct 25, 2002
Messages
11
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!
 

Excel Facts

Shade all formula cells
To shade all formula cells: Home, Find & Select, Formulas to select all formulas. Then apply a light fill color.

Joe Was

MrExcel MVP
Joined
Feb 19, 2002
Messages
7,539
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
 

Forum statistics

Threads
1,144,770
Messages
5,726,186
Members
422,661
Latest member
foxleinlady

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top