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.

"Halim" wrote:

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...
--

Regards,

Halim


"Sam" wrote:

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?