Module password

[gidon500]

Hi all

I am tring to use the Module password

i add a password to the document .

reload data , save module

re-enter

and nothing happen , it does not ask for the password

whar am i doing wrong

thanks

gidon

[Miguel_Angel_Baeyens]

Hi,

There is nothing wrong assuming you are setting the password in the Settings menu, Security, Module Password (it asks twice), then save and close, when you reopen the document, nothing happens. But when you try to get to the Module Editor (Ctrl + M) it prompts for the password. As its name says, Module password only protects the Module (macro) code, not the document.

Is there any other kind of password you want to set?

Miguel Angel Baeyens

BI Consultant

Comex Grupo Ibérica

[gidon500]

Hi ,

thanks for youe prompt answer

now i understand , it protects the module editor  .

I want to protect the module scripts ,

so no one can see it and change it

how  can i protect the script ?

gidon

[Miguel_Angel_Baeyens]

Hi Gidon,

Go to the Script Editor window, and in the File menu, Create a Hidden Script. That will ask you for a password, and will show you a new tab. You can create as many hidden tabs as you want. If you now copy your scripts in normal tabs to the hidden one and save and quit, the next time you open the document the charts and the information will be there, but the script will be hidden. You can now access to the hidden script in the File menu, Edit Hidden Script, make changes and quit.

Hope that helps.

Miguel Angel Baeyens

BI Consultant

Comex Grupo Ibérica

[gidon500]

Hi Miguel

thanks it seems to be working  .

How many  tabs of hidden script i can make 

it seems that i can make  only one  , is it correct ?

thanks

gidon

[Miguel_Angel_Baeyens · Accepted solution]

Hello Gidon,

Once you have set the password for the hidden script, and once you are in the hidden script tab (it appears with a key icon) you can create another tab that will appear hidden as well.

Hope that helps.

Miguel Angel Baeyens

BI Consultant

Comex Grupo Ibérica

[gidon500]

Hi

thank you very much ,

it works great

Gidon