Hi pswanie,

Your users shouldn't need to enter 'closing stocks'. All they should need to enter is stock received (if they receive any) and stock
sold. You should be able to use a formula to calculate the closing stocks, whe
Closing stock = Opening stock - Sold stock.
or
Closing stock = Opening stock + Received stock - Sold stock.
That way, the cell containing the Closing stock formula could be locked too.

But, even if the users have to enter closing stocks, that doesn't explain why the worksheet needs to be unprotected. If the users
fail to update the Closing stock figure, surely next time they open the workbook they could record the 'sold figure and the correct
Closing stock figure. Or they could just update the Closing stock figure, save & close the workbook - re-opening it again would then
carry the old Closing stock figure over as the new Opening stock figure.

Cheers
--
macropod
[MVP - Microsoft Word]
-------------------------

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