Add Code To Worksheet with VBA

[realniceguy5000]

Hi,

Once again I find myself having to edit some code in around 52 workbooks, each workbook has one sheet. I was able to use this code below to delete the problem worksheet code. However what I want now is to add some code back into the worksheet. I have seen several examples on how to add Mods and placing code into mods and even how to add code into Thisworkbook. but havent found anything about adding in sheet code.

Anyway does anyone know a way to add a private sub routine into a worksheet?

Here is what I used to remove the code. Can someone help modify this to add code back in?

Please Login or Register  to view this content.

Thanks as always, Mike

[romperstomper]

If you know how to add code into the ThisWorkbook module, there shouldn't really be much difference adding it to a worksheet module.
The fact that you are having to do this repeatedly suggests to me you might want to rethink whatever it is that you are doing...

[realniceguy5000]

If you know how to add code into the ThisWorkbook module, there shouldn't really be much difference adding it to a worksheet module.
The fact that you are having to do this repeatedly suggests to me you might want to rethink whatever it is that you are doing...

Understood, I'll work on some type of code and do some experimenting. This normally happens once a year since I create these workbooks.worksheets from last years templates from the previous year. I'm now working on 2011 workbooks for the year so that is why the change occurs. I just don't want to recreate the workbooks again is all.

I'll keep looking. Thank You,

[realniceguy5000]

If you know how to add code into the ThisWorkbook module, there shouldn't really be much difference adding it to a worksheet module.
The fact that you are having to do this repeatedly suggests to me you might want to rethink whatever it is that you are doing...

This wasn't so Hard After All.

Here is a solution should anyone find the need...

This will loop though all workbooks in a folder and delete the current procedure name and add the same procedure back with new code.

Please Login or Register  to view this content.

Please Login or Register  to view this content.