close

Is it possible to lock up certain cells in a spreadsheet to certain
users if the workbook is saves on a network? For example, Jim has
access to make changes to column D while Bill has access to make
changes to column G?
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(quot;usernamequot;) function.you also need to protect the VBA

hope this helps--
tony h
------------------------------------------------------------------------
tony h's Profile: www.excelforum.com/member.php...oamp;userid=21074
View this thread: www.excelforum.com/showthread...hreadid=501658

arrow
arrow
    全站熱搜
    創作者介紹
    創作者 software 的頭像
    software

    software

    software 發表在 痞客邦 留言(0) 人氣()

    E-mail轉寄