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

On Feb 17, 4:34*pm, John <john6...@comcast.com> 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.

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 <john6...@comcast.com> 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.
>
>

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
>

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
> >

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
>>>

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 <john6...@comcast.com> 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.
>