need a alternating password

[pswanie]

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..

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.

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.

i cant just write the code for an event and not have any formulas on the
spreadsheet itself coz im not always at a computer. im traveling a lot and
thus taking them through the problem telephonicly.

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


so basicaly i need a macro that will unlock the page but only after a
"password" has been enterd


thanx guys

 

[Gord Dibben]

I would suggest that your life would become much easier if you set up the
worksheet so's they don't have to field phone calls to unlock sheets for them to
edit locked cells.

All they have to do is pound data into the unlocked cells and formulas and VBA
beforeclose or beforesave code takes care of the rest.

Don't let them close or save the workbook until all data entry has beeen done
correctly.


Gord Dibben MS Excel MVP