Take a look at the website of Rob Bovey.http://www.appspro.com/Utilities/CodeCleaner.htmThere you will find among some other addins an addin to cleanyour VBA code.