VBA to paste a code snippet in the programatically created new worsheets's module

[kevivu]

All,

I have the below code to paste a code snippet in the programmatically created new worksheet's WORKSHEET (as this code is a worksheet change event)module. But its not working properly, sometimes giving error / sometimes pasting in the previously created sheets. My requirement is, whenever we create a new worksheet using another macro, the worksheet_change event code snippet should be pasted in the newly created worksheet's worksheet module.

Please Login or Register  to view this content.

Thanks

[Greg M]

Hi there,

See if the following code does what you need:

Please Login or Register  to view this content.

Hope this helps - please let me know how you get on.

Regards,

Greg M

[AlphaFrog]

Try something like this...

Please Login or Register  to view this content.

It may be easier to just have a template worksheet with code already in its worksheet code module and just copy it instead of adding a new blank sheet. The template sheet could be hidden if you like.

[kevivu]

Thanks a lot Greg & Alpha for your quick answers...

But thing is once again I am encountering an error only... I think I need to give my "Create sheet" code too to debug n help further.

Please Login or Register  to view this content.

[kevivu]

HI Alpha,

Thanks a lot and sorry to disturb you.. You have given the below suggestion... Can you please tell me how should i do that....

"It may be easier to just have a template worksheet with code already in its worksheet code module and just copy it instead of adding a new blank sheet. The template sheet could be hidden if you like."

Thanks.

[AlphaFrog]

This copies a hidden worksheet named Template

Please Login or Register  to view this content.