Protect VBA codes
 

How can i protect VBA codes from modifications and viewing using macros?
Currently i can only protect the codes by going to the VBA properties.
However, i am using macro to generate multiple excel files with modules and i
need to protect the excel file's module...is there any way to be done? like
coding ..etc?

Protect VBA codes
 

No, you have to do it manually. Wouldn't the virus writers love it if it were
otherwise?


On Sun, 30 Jan 2005 20:01:01 -0800, "Shirley"
wrote:

How can i protect VBA codes from modifications and viewing using macros?
Currently i can only protect the codes by going to the VBA properties.
However, i am using macro to generate multiple excel files with modules and i
need to protect the excel file's module...is there any way to be done? like
coding ..etc?

Protect VBA codes
 

sob sob...does it mean that there is no other way??

"Myrna Larson" wrote:

No, you have to do it manually. Wouldn't the virus writers love it if it were
otherwise?


On Sun, 30 Jan 2005 20:01:01 -0800, "Shirley"
wrote:

How can i protect VBA codes from modifications and viewing using macros?
Currently i can only protect the codes by going to the VBA properties.
However, i am using macro to generate multiple excel files with modules and i
need to protect the excel file's module...is there any way to be done? like
coding ..etc?

Protect VBA codes
 

HI,

you can do it but the only way to do so is using the SendKeys method

So long

Shirley a écrit :
sob sob...does it mean that there is no other way??

"Myrna Larson" wrote:


No, you have to do it manually. Wouldn't the virus writers love it if it were
otherwise?


On Sun, 30 Jan 2005 20:01:01 -0800, "Shirley"
wrote:


How can i protect VBA codes from modifications and viewing using macros?
Currently i can only protect the codes by going to the VBA properties.
However, i am using macro to generate multiple excel files with modules and i
need to protect the excel file's module...is there any way to be done? like
coding ..etc?