I know this may be slightly longer winded than just a text box sat o
the screen but hope this helps or at least points in the righ
direction...
Keep your button on the sheet and have it call the Macro "InputBox"
-------------
Sub InputBox()
macro = Application.InputBox("Enter Macro Number")
Run ([macro])
End Sub
------------
Clicking your button will now open an input box which asks for th
macro name you would like to run. If you had a macro called "Print" an
entered Print in this box then that macro would run.
Joh
--
johncassel
-----------------------------------------------------------------------
johncassell's Profile:
http://www.excelforum.com/member.php...fo&userid=2501
View this thread:
http://www.excelforum.com/showthread.php?threadid=54271