Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Create Drop Down List of Macros | Excel Discussion (Misc queries) | |||
Macros in Personal.xls that would create two toolbars and buttonswith assigned macros | Excel Programming | |||
How to create adress list so can mail merge and create labels? | Excel Discussion (Misc queries) | |||
Macros not appearing in the Tools Macro Macros list | Excel Programming | |||
List the Macros that can be executed from Tools-Macros | Excel Programming |