Thread: interactive vba
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Hervé Hanuise Hervé Hanuise is offline
external usenet poster
 
Posts: 5
Default 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+