| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Worksheet controller
Please guys...any help....am scratching my head for this. ......  -- 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 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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. ...... -- 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 |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Worksheet controller
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Protect Workbook vs Worksheet?? | Excel Worksheet Functions | |||
| Inserting Filtered RC cell information into other worksheets | Excel Discussion (Misc queries) | |||
| Search/Match between 2 x separate Worksheets and populate result in third worksheet | Excel Discussion (Misc queries) | |||
| Weekly Transaction Processing | Excel Worksheet Functions | |||
| copyright and worksheet protection | Excel Discussion (Misc queries) | |||
Linear Mode
