Create list of macros
 

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

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.

Create list of macros
 

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

"CurlyDave" wrote:

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.

Create list of macros
 

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.



"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

Create list of macros
 

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.


"JLGWhiz" wrote:

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.



"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

Create list of macros
 

Sounds interesting. I know nothing about it though.
John

MeistersingerVonNurnberg wrote:
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.


"JLGWhiz" wrote:

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.



"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

Create list of macros
 

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

CurlyDave wrote:
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.