Edit Excel Worksheet VBA using VBA?

[LastDance74]

I have an Excel worksheet that, depending on selections made by the user, generates a new worksheet in the same workbook.

I have all this working fine but have hit a problem when trying to add a command buttons on_click event code and a few other little subprocedures to the new worksheet.

Is it possible to edit the new sheets code using VBA at runtime? When I create the Command button object how do I set it's events?

Thanks for any insight
Sam.

 

[SkipVought]

Hi,
When you add the button, assign the OnAction property to the macro you want to execute...

ActiveSheet.CommandButton1.OnAction = "MacroName"

I would imagine that procedure, MacroName, would have to be generalized to perform the desired actios.

I hope that this helps. Skip,
metzgsk@voughtaircraft.com