Thread: tricky password
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
pswanie pswanie is offline
external usenet poster
 
Posts: 247
Default tricky password

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