I don't have this information any more.But I just did a Google search. My keywords: excel vba modify programmodules from codeThis hit http://www.cpearson.com/excel/vbe.aspx looks promising.