Hi

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

Thanks

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" skrev i melding
...
Hi

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

Thanks

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" skrev i
melding
...
Hi

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

Thanks


.

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

--

HTH

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


"nc" wrote in message
...
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" skrev i
melding
...
Hi

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

Thanks


.

Thanks.

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

-----Original Message-----
Be aware though, it is not foolproof, it is easily
broken.

--

HTH

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


"nc" wrote in
message
...
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" skrev i
melding
...
Hi

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

Thanks


.



.

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)


"nc" wrote in message
...
Thanks.

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

-----Original Message-----
Be aware though, it is not foolproof, it is easily
broken.

--

HTH

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


"nc" wrote in
message
...
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" skrev i
melding
...
Hi

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

Thanks


.



.

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

Thanks

"Bob Phillips" wrote in message
...
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

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)


"Marc" wrote in message
...
Does it makes complicated to broken if you enter password with 20 words,
for
example: tv5kZsP8767hj;%j#L

Thanks