I want to lock the project code from being viewed, but one of the macros contained in the workbook saves the file in CSV format and when the code is locked it prevents the macro from executing.

does anyone know a way round it