High Security setting
 

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?

High Security setting
 

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?

High Security setting
 

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?

High Security setting
 

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

"Sam" wrote in message
...
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?