View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.programming
John[_19_] John[_19_] is offline
external usenet poster
 
Posts: 87
Default 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