Thread: Locking cells only for certain users
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
tony h
 
Posts: n/a
Default Locking cells only for certain users

you can use an event like the workbook.open to execute some code that
changes the protection on the cells dependant upon the user. The user
can be determined using the environ("username") function.


you also need to protect the VBA

hope this helps


--
tony h
------------------------------------------------------------------------
tony h's Profile: http://www.excelforum.com/member.php...o&userid=21074
View this thread: http://www.excelforum.com/showthread...hreadid=501658

Reply With QuoteReply With Quote