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


.



.