View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
curlydave curlydave is offline
external usenet poster
 
Posts: 206
Default Create list of macros

On Feb 17, 4:34*pm, John wrote:
I would like to present user with a list of macros with explanations of
what they do. Have one button that is "Macros" and that opens a macro
(or something) that lists the macros. Then can select one to run.

Thanks

John


Alt&F8 ?
This shows all the macros in the WorkBook, if you have made
explanations for each macro they will show there.

Another other way would be to create a userform with command buttons,
and each button would have your separate VBA code, you could have an
explanation of what each button does beside the command button.