Protect Macros

[nc]

Hi

How can I protect macros for a workbook without
protecting the workbook/worksheet?

Thanks

 

[Harald Staff]

Hi

Open the VB editor. Undert Tools menu there's a "project properties" item
and there you'll find a "Protection" window.

HTH. Best wishes Harald

 

[nc]

Thanks Harald

-----Original Message-----
Hi

Open the VB editor. Undert Tools menu there's a "project properties" item
and there you'll find a "Protection" window.

HTH. Best wishes Harald

"nc" <[email protected]> skrev i melding


.

 

[Bob Phillips]

Be aware though, it is not foolproof, it is easily broken.

--

HTH

RP
(remove nothere from the email address if mailing direct)

 

[nc]

Thanks.

Once it is locked in properties, can it only be locked by
closing and reopening the file?

 

[Bob Phillips]

No, when you go into the VBE and try and access the project, it will prompt
for the password.

It gets broken at the file level, not in the VBE. It will deter casual
lookers.

--

HTH

RP
(remove nothere from the email address if mailing direct)

 

[Marc]

Does it makes complicated to broken if you enter password with 20 words, for
example: tv5kZsP8767hj;%j#L

Thanks

 

[Fredrik Wahlgren]

No, when you go into the VBE and try and access the project, it will prompt
for the password.

It gets broken at the file level, not in the VBE. It will deter casual
lookers.

--

If you want a higher level of protection, you can make a COM add-in using
VB6 or a .NET language. How much protection do you feel is necessary. Whom
do you want to protect your code from?

/Fredrik

 

[Bob Phillips]

No, because when you break it you don't even see (or care) about what the
original password was.

--

HTH

RP
(remove nothere from the email address if mailing direct)