Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
allowing users to change their row ONLY
I'm hoping to set up a master spreadsheet for a soccer team that would allow players to input daily training on their individual rows. They would be locked out of inputting data on anyone elses row. This way, the coach would only have to look at the master spreadsheet set up on the club web site to see who is following the schedule. Is this possible. Thanks. -- debra ------------------------------------------------------------------------ debra's Profile: http://www.excelforum.com/member.php...o&userid=29339 View this thread: http://www.excelforum.com/showthread...hreadid=490506 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
allowing users to change their row ONLY
Maybe...
If the coach and all the users are using xl2002+, you can protect ranges and make a potential editor provide a password to edit that range. Tools|Protection|allow users to edit ranges. The worksheet needs to be protected for this to have any effect. But worksheet protection isn't made for security purposes. It's easily broken. So if that's a problem, maybe just providing a dedicated workbook to each player would be better. debra wrote: I'm hoping to set up a master spreadsheet for a soccer team that would allow players to input daily training on their individual rows. They would be locked out of inputting data on anyone elses row. This way, the coach would only have to look at the master spreadsheet set up on the club web site to see who is following the schedule. Is this possible. Thanks. -- debra ------------------------------------------------------------------------ debra's Profile: http://www.excelforum.com/member.php...o&userid=29339 View this thread: http://www.excelforum.com/showthread...hreadid=490506 -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
change info in other cells when i change a number in a drop list? | Excel Discussion (Misc queries) | |||
How do I get the font color to change automatically depending on | Excel Discussion (Misc queries) | |||
How do I link two cells as to allow me to change the value in eit. | Excel Discussion (Misc queries) | |||
Use DocProps in a change declaration | Excel Worksheet Functions | |||
automatic color change in cells using a drop down list | Excel Worksheet Functions |