Using a macro to add code to a newly created workbook.

I think it has been taken care of. However if it hasn't I am working on another solution as well if that works I will post it here also. Thanks for your help. Also if it helps I am doing all of this with files on a shared network drive.