Allow certain users to edit certain rows?
 

Hi,

I'm trying to set up a request schedule, whereby users can log-in an
then enter their preferred shifts for the coming month.

They must not be able to edit anyone else's requests, and can onl
enter their own once.

Is this possible with Excel? Can someone point me in the righ
direction, please, for a possible solution?

many thanks!

Davi

--
hay777
-----------------------------------------------------------------------
hay7777's Profile: http://www.excelforum.com/member.php...fo&userid=1506
View this thread: http://www.excelforum.com/showthread.php?threadid=26693

Allow certain users to edit certain rows?
 

David,
You could set up named ranges based on logon ids and then
protect certain named ranges (with VBA). Or have a sheet
for each user and prtoect the sheets. Also have a look for
an API called GetUserName that get's the user's network
ID. Could save the user from actually having to enter an
id, thus reducing the annoyance factor.
Good luck.
Geof.
-----Original Message-----

Hi,

I'm trying to set up a request schedule, whereby users
can log-in and
then enter their preferred shifts for the coming month.

They must not be able to edit anyone else's requests, and
can only
enter their own once.

Is this possible with Excel? Can someone point me in the
right
direction, please, for a possible solution?

many thanks!

David


--
hay7777
----------------------------------------------------------
--------------
hay7777's Profile: http://www.excelforum.com/member.php?
action=getinfo&userid=15066
View this thread:
http://www.excelforum.com/showthread...hreadid=266937

.

Allow certain users to edit certain rows?
 

Forgot the "edit only once part". You could write out the
userid and date to a log worksheet (audit trail) upon
closing the workbook. Next time the user log in you could
check the log sheet.
Geof.
..-----Original Message-----

Hi,

I'm trying to set up a request schedule, whereby users
can log-in and
then enter their preferred shifts for the coming month.

They must not be able to edit anyone else's requests, and
can only
enter their own once.

Is this possible with Excel? Can someone point me in the
right
direction, please, for a possible solution?

many thanks!

David


--
hay7777
----------------------------------------------------------
--------------
hay7777's Profile: http://www.excelforum.com/member.php?
action=getinfo&userid=15066
View this thread:
http://www.excelforum.com/showthread...hreadid=266937

.