I have found references and code on the net which helps me add code in the
form of an Excel Macro. However it shows how to create a new module and then
add functions to it. How to add functions to the thisWorkbook part of the
File.

the link that shows how to programatically add macro o a new module is:
http://support.microsoft.com/kb/303872

i dont want to add it to a new module but to "ThisWorkbook"

Please help