Hi,


I was able to create a button to the active sheet from my vba project but I
would also like to "insert" and module on the active sheet on the fly.


So far, the module called "hide" is in my current project but I would like
to transmit this module to the new created sheet along with the button.

is it possible.?


Thank you very much.


Thanks for your help



cesar

Look in Chip Pearsons page on working with the VBE programmatically

http://www.cpearson.com/excel/vbe.htm

Regards,
Tom Ogilvy


"Cesar Zapata" wrote in message
...
Hi,


I was able to create a button to the active sheet from my vba project but
I
would also like to "insert" and module on the active sheet on the fly.


So far, the module called "hide" is in my current project but I would like
to transmit this module to the new created sheet along with the button.

is it possible.?


Thank you very much.


Thanks for your help



cesar

his site seems to be "down" :(




thanks,



"Tom Ogilvy" wrote in message
...
Look in Chip Pearsons page on working with the VBE programmatically

http://www.cpearson.com/excel/vbe.htm

Regards,
Tom Ogilvy


"Cesar Zapata" wrote in message
...
Hi,


I was able to create a button to the active sheet from my vba project
but
I
would also like to "insert" and module on the active sheet on the fly.


So far, the module called "hide" is in my current project but I would
like
to transmit this module to the new created sheet along with the button.

is it possible.?


Thank you very much.


Thanks for your help



cesar