High Security setting

[Sam]

An app was opened while the user was set to High Security that disabled all
macros. This user then saved the app. When I checked the file, all code was
missing. This has happened a few times.
1. Does this process actually remove all vba modules?
2. If so, is there any way of preventing this?

 

[Halim]

1. Excel doesn't remove your module anyway unless you use the code to
process it.
2. Check your vba code that containing procedure to delete/remove module...
or set the security as Low...

 

[Sam]

I am not the end-user of the app. All users know to set Security on Medium,
but if IT works on their PC, it sometimes defaults Office to High Security.
An inexperienced user may save the app when disabling macros. This is where
the issue arises. I have seen all code eliminated.

 

[NickHK]

As Halim pointed out, Macro Security does not delete VBA code on its own; it
just prevents it from running.
I cannot reproduce your produce with XL2K or XLXP.
Maybe a virus scanner or add-in is responsible ?

NickHK