Workbook_Open code deleting all code

[capbbk]

Help.

all of a sudden whenever I add code in the workbook_open sub and save the file, all of my code is deleted. I can add the other non-workbook_open code back save and reopen the file and all is good. as soon as i put code back in the workbook_open, it all gone again!

 

[xenou]

This is very unusual and probably has no good explanation. Chalk it up to experience and revert back to the last version of your project where things were working.
ξ

 

[capbbk]

Thank you for the reply.

Unfortunately this happens everytime and to any excel file I modify. As soon as I save and re-open with code in the workbook_open, all code is lost. If I don't have code in the workbook_open, the code is saved and retained normally.

 

[Ruddles]

Does this happen if you open the workbook with macros disabled?