Can vba be used to move code to a new workbook?

[Xaos]

Hello

I have a code to create a new workbook. I would like to add a Worksheet_SelectionChange code to one of the created worksheets.

Is it possible to automate this during the vba create process?

Thanks

[Norie]

You could write code to create code but it might be easier to have a template worksheet with the SelectionChange code in it and copy that to the new workbook.

[Xaos]

The reason I'm asking is because I will be using a code to make lots of workbooks. I was hoping I could automate the process of copying a bit of code so I wouldn't have to do it hundreds of times.

[Norie]

Yes you can do it, but it would be easier to work with a template worksheet no matter how many workbooks you are creating.

For example to create a new workbook and copy a template worksheet to it:

Please Login or Register  to view this content.

To add the SelectionChange event to a worksheet in a newly created workbook using code:

Please Login or Register  to view this content.

That's a very simple example and only creates code for a message box.

[Xaos]

Excellent. Now I have something to play with. I really appreciate your help.