VBA - Splitting worksheet by Dept

Hi,

Please take a copy of your file, and test this method on it:

• Rename your file extension from WorkbookName.xlsm to WorkbookName.zip
• To be able to apply the previous step, you have to display filename extensions if it's not displayed, please follow this https://www.howtogeek.com/205086/beginner-how-to-make-windows-show-file-extensions/ to learn how to display them
• Open the zip file and find out a file called (vbaProject.bin) inside xl folder, then delete it
• After that, change the file extension back to WorkbookName.xlsm

Now the VBA Project is gone, but please note that the VBA Project would still appear in the VBA editor because you cannot delete it at all, but the process above will clear the VBA project and delete all modules and any line of code stored in ThisWorkbook and worksheets code modules.

Hope that helps