ive allready unlock the cells that they supposed to type in. in effect its
a inventory workbook. they need to enter closing stocks and stocks sold. but
now they mess up and dont check before they close and clear. close and clear
carries the closing over and use it as the new opening.

"pswanie" wrote:

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