View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
macropod macropod is offline
external usenet poster
 
Posts: 329
Default one per day password

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
--
macropod
[MVP - Microsoft Word]
-------------------------

"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