Why not write the code for an event and not have any formulas on the
spreadsheet itself?


"pswanie" wrote in message
...
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