LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
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

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Tricky one LondonJames Excel Worksheet Functions 1 January 17th 12 01:11 PM
Tricky Tricky episode 2!!! mhax[_13_] Excel Programming 5 July 21st 06 03:15 PM
Tricky Tricky episode 2!!! Bernie Deitrick Excel Programming 0 July 20th 06 07:01 PM
PASSWORD REMOVAL I have the password to open the file and the password to modify the file now how to remove them LJ[_4_] Excel Programming 0 April 27th 06 03:18 AM
Mmm tricky- but i'm sure someone out there can help! ali Excel Programming 1 December 6th 03 08:06 PM


All times are GMT +1. The time now is 03:56 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"