I've been working for months and months on a complex workbook designed for use by many different people in many locations within a large organization. Thanks to all of those whom helped me over the many hurdles I encountered!
I know that there are 29 user forms and 14 modules (that's obvious), but is there a way to figure out how many individual macros and lines of code I've created? I think it's over 5,000 lines of actual code, with hundreds of lines of comments on top of that. Now that I'm just tying up the loose ends and ready to submit this file to my supervisor, I'd like to be able to provide them with some "wow" statistics because I don't think the average person understands what goes into a complex workbook with tons of macros and forms. Lastly, I've heard of some external applications that will pull lots of analytics about an excel workbook, but I work on a very secure LAN without internet, and definitely no user permissions to install secondary applications. Thanks!
I know that there are 29 user forms and 14 modules (that's obvious), but is there a way to figure out how many individual macros and lines of code I've created? I think it's over 5,000 lines of actual code, with hundreds of lines of comments on top of that. Now that I'm just tying up the loose ends and ready to submit this file to my supervisor, I'd like to be able to provide them with some "wow" statistics because I don't think the average person understands what goes into a complex workbook with tons of macros and forms. Lastly, I've heard of some external applications that will pull lots of analytics about an excel workbook, but I work on a very secure LAN without internet, and definitely no user permissions to install secondary applications. Thanks!
