hey

i need to add a cmd button (edit) to my sheet. (that i got) when they click
it, it should unprotect the page.

But heres the twist for the clever guys...

before unlocking the sheet it needs to bring up a userform. on that i need
it to have a "hint" and a open block to type the password and a cancell and
okay button. for example if the hint read "mountain" then i look up on my
side and see that word goes with 2486. and if it reads "chicken" i know it
goes with 8520 and if it reads "paper" it goes with 6547. i will keep the
list with 25 or so words and the corresponding passwords with me.

when my guys need to edit anything in a locked cell they then hit the "edit"
button and call me with the word. i give them the number password but after
hitting the "ok" it then needs to delete that word and password. that will
keep them from using the "alt" "t" "p" "p". they now do that and screw around
where they dont need to .every so often i will then update the list of words
and passwords.

thanx everyone

phillip

Kind of confused about what you mean by a word going with a number, is the
number their ID? Is it a particular cell number? What I personally would do
in a situation like that is store in code a list of 25 words, each assigned a
number, when the box pops up it gives them a number, they call you with
number, you give them associated password. When they enter it, the code will
check to make sure that is correct and when done (on close?) it will randomly
generate another number and password protect it with the corresponding word.
Next time it opens the userform it will look up that word and display the
corresponding number and the process repeats.
--
-John
Please rate when your question is answered to help us and others know what
is helpful.


"pswanie" wrote:

hey

i need to add a cmd button (edit) to my sheet. (that i got) when they click
it, it should unprotect the page.

But heres the twist for the clever guys...

before unlocking the sheet it needs to bring up a userform. on that i need
it to have a "hint" and a open block to type the password and a cancell and
okay button. for example if the hint read "mountain" then i look up on my
side and see that word goes with 2486. and if it reads "chicken" i know it
goes with 8520 and if it reads "paper" it goes with 6547. i will keep the
list with 25 or so words and the corresponding passwords with me.

when my guys need to edit anything in a locked cell they then hit the "edit"
button and call me with the word. i give them the number password but after
hitting the "ok" it then needs to delete that word and password. that will
keep them from using the "alt" "t" "p" "p". they now do that and screw around
where they dont need to .every so often i will then update the list of words
and passwords.

thanx everyone

phillip

see my previous posting. that should explain a litle beter wat i need.
essentialy i think what i need is like a alternating or a once of password to
unprotect a protected sheet and then protect it again so if they need edit it
again they must call. search pswanie and u should see my last posting of
about 3days back.

phillip

see my previous posting. that should explain a litle beter wat i need.
essentialy i think what i need is like a alternating or a once of password to
unprotect a protected sheet and then protect it again so if they need edit it
again they must call. search pswanie and u should see my last posting of
about 3days back.

phillip