Allow certain users to edit certain rows?
 

Geof Wyght Wrote:[color=blue]
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.

Thanks for the ideas! Yep - that's what I'm looking for. Is i
possible to protect certain ranges with VB in Excel 2000? If so, an
ideas where to start?

Geof Wyght Wrote:
You could write out the
userid and date to a log worksheet (audit trail) upon
closing the workbook

That sounds cool. Is there a seperate function to do this? Would th
worksheet be a part of the document, or a different one?

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,
Yes there is a way. I was a bit sloppy with my terms.
If the worksheet is protected you want to unprotect it:
Worksheets(1).Protect (with the False arguments)
Then unlock the named range in question:
Range("david").Locked = False
Lock all the others. I assume you have a list of users.
Range("geof").Locked = False ...
Then protect the sheet again
Hope that gets you going...
Geof.
-----Original Message-----

Geof Wyght Wrote:
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[color=blue]
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.

Thanks for the ideas! Yep - that's what I'm looking
for. Is it
possible to protect certain ranges with VB in Excel
2000? If so, any
ideas where to start?

Geof Wyght Wrote:
You could write out the
userid and date to a log worksheet (audit trail) upon
closing the workbook

That sounds cool. Is there a seperate function to do
this? Would the
worksheet be a part of the document, or a different
one?

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

.