Protect Macros

N

nc

Hi

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

Thanks
 
H

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
 
B

Bob Phillips

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

--

HTH

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

nc

Thanks.

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

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)
 
M

Marc

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

Thanks
 
F

Fredrik Wahlgren

Bob Phillips said:
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.

--
Click to expand...

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
 
B

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)
 
Top