Create list of macros

[John]

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

 

[CurlyDave]

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.

 

[JLGWhiz]

Alt + F8 only shows the procedures in the public module. It does not show
any sheet code, ThisWorkbook code or UserForm code.

 

[JLGWhiz]

R.B. Smissert posted this in another thread:

This .xla add-in:
http://tinyurl.com/rrw3p
Has an extensive workbook documenter and it will amongst many
other things list all your macro's.

 

[MeistersingerVonNurnberg]

Hi -

You could dynamically create a toolbar or menu at startup with the
respective caption of each button / item being the description you mention.
Each button / item would be mapped to the appropriate (public) sub's.

You can use the CommandBars collection, the Controls collection for each
CommandBar, and the .Caption, and .OnAction properties.

Don't forget to tear down your tb or menu when done / closing.

 

[John]

Sounds interesting. I know nothing about it though.
John

 

[John]

I'm toying with the userform route. Looks pro,issing but it seems really
hard designing decent looking textboxes in excel. I can get done what I
want to do but it looks terrible.

John