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

i got a workbook thats used on 5 machines on diffrent locations. the ppl
using it are not all that computer litterate...

at the moment i tell them to "alt" "t" "t" "p" to unlock the page if they
need to manualy change anything in a locked cell. problem are they now erase
my formulas..

are there any how that i can have them to call me for a password? if they
for example click on a button it will give them a "screen" with a word wich
they then read to me. i then know what 5 digits to give to them to type in
that "screen". this will then unlock the worksheet for either a set time or
till they close the workbook.

next time they open it they cant edit a locked cell with out calling me

thanx guys