The quick way to see the macros is to press ALT-F8. If you want to control
what they see, you can create a macro that displays a list box of macros, or
a set of option buttons that list the macros. Once a selection is made, it
can execute the macros.

You can assign the above macro to a button or to a menu item on say the
Tools menu for easy access.

If it is likely that you would be modifying the macros, you should consider
putting the macros in an workbook that is an add-in (a property setting of a
workbook) so that you can do replacements easily.

Bob Flanagan
Macro Systems
http://www.add-ins.com
Productivity add-ins and downloadable books on VB macros for Excel

"Smonczka" wrote in message
ups.com...
I am looking for a way to create a pop up that would ask the user if
they would like to run a macro.

The worksheet has several macros that will alter the sheet in several
ways, either by saving as a new file or altering the formatting.
Users will only want to run one of these macros at any one time. I'm
trying to find a reference that would show me how to create a pop up
window that would list the available macros in the sheet and ask the
user which one they would like to run.

Thanks for any help you can give,
Steve