hi all and thanks for any help you may be able to give me. let me tell you what i am trying to do...

i have a macro that lives in my workbook. the source code is protected at this level via right click on module, properties, protection...works great for THIS workbook.

my problem is that when i run this macro, it creates a new workbook (that also contains code) but then the code that WAS protected in the orgianl workbook is now not procted in the new one...

is there a way to add in a bit of code to the main workbook that says

"when i run and build a new workbook, i will protect that workbooks source code too?"

thanks for the help.

-wm