One place for your PW

[Frigide]

In a sheet i have several macro's to lock or unlock a sheet/line/cell.

For example:

Please Login or Register  to view this content.

Is there a way to place a PW somewhere and to call it. So when i want to change the PW there is one place to change it.

[KOKOSEK]

I am not sure that I understand correctly:

Please Login or Register  to view this content.

[Frigide]

Is there a way to place it somewhere and use it in several macro's?

[sintek]

Yes...Place it in a cell on a sheet...or store it in a public variable...
Taking into account that there is no real security in Excel...

Please Login or Register  to view this content.

Please Login or Register  to view this content.

[Frigide]

I know there is no security in excel. I use a PW so the people with slim knowledge of excel don't mes thins up.

So when use the code:

Please Login or Register  to view this content.

And sheet shY is xlVeryHidden it wil work?

[sintek]

Yes...I assume all is declared...

Please Login or Register  to view this content.

[Frigide]

I never use the dim..

Please Login or Register  to view this content.

Why is this necessary?

[sintek]

Mainly because it is important to declare your variables...Makes it easier to find errors...
See here why Option Explicit declaration for your workbooks is important...

Did you manually name your sheets in the VBE Project to shY and shP ? from default names Sheet1 etc etc

[Frigide]

I don't get it to work.

I use a userform for typing/asking for a PW with this code.

Please Login or Register  to view this content.

For a lot of unlocking i wan't to use a PW placed somewhere central so i can change it easy.

And unlock a script lock this.

Please Login or Register  to view this content.

Or script like this.

Please Login or Register  to view this content.

But for one script i want to use another PW.

Please Login or Register  to view this content.

Is this even possible?

[sintek]

Time to upload a sample file so that you can be put out of your misery...
Explain in detail by referencing requirements...