| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to retrive password protected worksheet but forgot password? | Excel Worksheet Functions | |||
| PASSWORD REMOVAL I have the password to open the file and the password to modify the file now how to remove them | Excel Programming | |||
| How do I unprotect/with password to run marco and protect | Excel Programming | |||
| how to automate opening a password protected excel file? e.g. a .xls that has a password set in the security tab. | Excel Worksheet Functions | |||
| bypass password when update linking of password protected file | Excel Discussion (Misc queries) | |||
![Elton Law[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
