Macro enabled workbook loses its vba on close and re-open

[XLJunky]

I use an activeworkbook.saveas filename:=..., fileformat:=52 statement in vba to save a book for which i have inserted vba into its Thisworkbook Before_Save event procedure. It's there after the save, but when I close and then re-open the newly created workbook, the vba is no longer present in the ThisWorkbook module. It worked a few weeks ago. Why is the code getting wiped out? Any help would be greatly appreciated, Rick.

 

[XLJunky]

Apparently, some program, possibly McAfee, does like when one module attempts to write code to another module. I was doing this when putting the snippet of code in to the ThisWorkbook mod. Anyway, my add-in is now back to one big module, and all is well. My resultant book now retains its code. Thanks much for your consideration, Rick.

 

[XLJunky]

does NOT like