Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
interactive vba
Hi !
In the project I have, and for didactical purpose, I would like to automatically populate a "Commands" sheet with buttons: one button per existing SUB of the vba module. As my workbook starts empty, I want to automatically : - add a new sheet and name it "Commands" - populate the sheet with one button per existing vba SUB in the module. Does anyone have ideas for doing this automatically ? Thanks and very best regards+ |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
interactive vba
See Chip Pearson's site for the type of code you need to identify your subs:
http://www.cpearson.com/excel/vbe.htm -- Regards, Tom Ogilvy "Hervé Hanuise" wrote in message ... Hi ! In the project I have, and for didactical purpose, I would like to automatically populate a "Commands" sheet with buttons: one button per existing SUB of the vba module. As my workbook starts empty, I want to automatically : - add a new sheet and name it "Commands" - populate the sheet with one button per existing vba SUB in the module. Does anyone have ideas for doing this automatically ? Thanks and very best regards+ |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Interactive course | New Users to Excel | |||
Interactive Workbook | Excel Discussion (Misc queries) | |||
Interactive Buttons | Excel Discussion (Misc queries) | |||
Interactive Worksheet | Excel Discussion (Misc queries) | |||
iNTERACTIVE EXCEL FILE NOT INTERACTIVE ON THE WEB | Excel Discussion (Misc queries) |