Marco Password
 

Dear Expert,
I Know this is easy question ... Anyway, hope someone can help me to resolve
this stipud question.
How to protect the marco with password so that people can see the scripts
but cannot change the content please

Marco Password
 

Excel doesn't have that level of security, in fact Excel security is
poor to say the least, the only options open to you are to lock the
project for viewing so you cannot see the code without entering a
password, or you can protect the project properties which is nothing
more than protecting information about the project.

Elton Law;317072 Wrote:
Dear Expert,
I Know this is easy question ... Anyway, hope someone can help me to
resolve
this stipud question.
How to protect the marco with password so that people can see the
scripts
but cannot change the content please


--
Simon Lloyd

Regards,
Simon Lloyd
'The Code Cage' (http://www.thecodecage.com)
------------------------------------------------------------------------
Simon Lloyd's Profile: http://www.thecodecage.com/forumz/member.php?userid=1
View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=88682

Marco Password
 

Possibly document the code in a separate worksheet or file and lock the
code.
--
Steve

"Simon Lloyd" wrote in message
...

Excel doesn't have that level of security, in fact Excel security is
poor to say the least, the only options open to you are to lock the
project for viewing so you cannot see the code without entering a
password, or you can protect the project properties which is nothing
more than protecting information about the project.

Elton Law;317072 Wrote:
Dear Expert,
I Know this is easy question ... Anyway, hope someone can help me to
resolve
this stipud question.
How to protect the marco with password so that people can see the
scripts
but cannot change the content please


--
Simon Lloyd

Regards,
Simon Lloyd
'The Code Cage' (http://www.thecodecage.com)
------------------------------------------------------------------------
Simon Lloyd's Profile:
http://www.thecodecage.com/forumz/member.php?userid=1
View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=88682