one per day 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..

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

 

[Mark Ivey]

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

 

[pswanie]

im not always at a computer. im traveling a lot and thus taking them through
the problem telephonicly.

 

[theSquirrel]

im not always at a computer. im traveling a lot and thus taking them through
the problem telephonicly.

I wrote some time back for a friend some code that did what you are
asking for... I never got a chance to see the final implementation
but if another can use it, give it a try. The link below has a ZIP
with 2 files, the first is the KeyForm. This is the UserForm you will
put on any sheet you want the users to unlock. The second is the
KeyGen book. I has the code to generate unlock codes for the code on
the KeyForm.

http://www.mediafire.com/?4mnteuyzox3

I know most aren't keen on running or opening code they from the web,
but its there if you want it.

theSquirrel

 

[macropod]

Hi pswanie,

If there are non-formula cells that your users are supposed to be able to change, why not unlock them before protecting the
workbook?

Cheers

 

[pswanie]

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.

 

[macropod]

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, where:
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