What you need is VBA code that can read VBA code. That's not too difficult. See this link: http://www.cpearson.com/excel/vbe.htm

One caution ... it won't work if the user has Excel 2002+ (I think I have the version right) and had NOT set macro security to "Trust Access to Visual Basic Project". Of course, very few pople HAVE done this since they have no idea what it means, and it sounds risky. So, be sure that your code tests for this (by ignoring errors, attempting to access VBProject, then checking to see if an error was raised), or you will put in a lot of work for no satisfaction.