Locked VBA projects are not unprotected under any circumstances. Ribbon Commander's Code Cleaner can read and clean both unlocked & locked VBA projects.Įnd users can clean 3rd party protected add-ins, when stability issues are experienced during loading or running code.This a loophole for the security minded, as these text files can be undeleted easily by file recovery software. Traditional cleaning involves exporting all VBA components to text files on disc.Check if your files are already clean using the. Multiple closed files can be cleaned very fast by Ribbon Commander.This translates to significant time savings, as massive workbooks may require even minutes to open and save. CleanVBAProject method does NOT open files in Excel.