Worksheet controller

P

praveen_khm

Hi all,

I am creating a attendance tracker. I need your help for the
completion.

I am looking for a control which can track the changes. To be more
specific, If a person updates the data in the sheet once, it should be
locked. The next time, he/she should not be able to update it. It
should be possible only with a controller who can in turn give a
password and then make the necessary changes. I am not using any macros
and it runs only on formulas. Please help me in this for the completion.
I am already breaking my head for this.

Your help is appreciated,
Thanks in advance,
Praveen :)
 
M

Minerva

If you want to block further change to the file, you could make it 'password
protected' once you are done with it once. Tools menu/Protection/Protect
Sheet option will do that..........so next time anybody opens the file they
need to know and give the password to make the changes.
 
P

praveen_khm

:mad: Thanks for your response Minerva,

But I am looking for something which can control the cells.... as i
have mentioned, I am looking for a control to each cell....

anyways, thanks again.....

Praveen...
 
Top