View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
SeventhFloorProfessor SeventhFloorProfessor is offline
external usenet poster
 
Posts: 6
Default Prompt User to Select Macro to Run?

Is it possible to have a macro run that prompts the user to select which
macro to run? If so, how would that be coded?

The situation:

I am creating a workbook that will guide the user to create a "template"
(not as a literal file, but in the sense that this will be the starting
workbook), which the user will be prompted to save as another file name (this
will be their personal template for their class). Since I am creating this
for teachers who are not familiar with macros, I would like to store the
various macros I have written in one workbook, and then prompt the user to
select which macro to run, depending on what they want to do...

help!