Hi,

have no idea if applicable in your case, but in similar situation
helped me to export all the modules and import them into a new
workbook.

Regards,
Ivan