How to call a function from a ComandButton on an excel sheet created dynamically

[ravikanth180]

Hi All,

I have a workbook A which creates an excel sheet dynamically and then creates a Command button on that sheet.
I need to assign an onclick event dynamically to the commandbutton which calls a function in workbook A.

Please Help me !!

[AlphaFrog]

This link may help...

Extensibility: Programming The VBA Editor