View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Dave Peterson
 
Posts: n/a
Default 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