Worksheet controller
 

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 :)


--
praveen_khm
------------------------------------------------------------------------
praveen_khm's Profile: http://www.excelforum.com/member.php...o&userid=30364
View this thread: http://www.excelforum.com/showthread...hreadid=509024

Worksheet controller
 

Please guys...any help....am scratching my head for this. ......:mad:


--
praveen_khm
------------------------------------------------------------------------
praveen_khm's Profile: http://www.excelforum.com/member.php...o&userid=30364
View this thread: http://www.excelforum.com/showthread...hreadid=509024

Worksheet controller
 

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.


"praveen_khm" wrote:


Please guys...any help....am scratching my head for this. ......:mad:


--
praveen_khm
------------------------------------------------------------------------
praveen_khm's Profile: http://www.excelforum.com/member.php...o&userid=30364
View this thread: http://www.excelforum.com/showthread...hreadid=509024

Worksheet controller
 

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


--
praveen_khm
------------------------------------------------------------------------
praveen_khm's Profile: http://www.excelforum.com/member.php...o&userid=30364
View this thread: http://www.excelforum.com/showthread...hreadid=509024