Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Tricky one | Excel Worksheet Functions | |||
Tricky Tricky episode 2!!! | Excel Programming | |||
Tricky Tricky episode 2!!! | Excel Programming | |||
PASSWORD REMOVAL I have the password to open the file and the password to modify the file now how to remove them | Excel Programming | |||
Mmm tricky- but i'm sure someone out there can help! | Excel Programming |