Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Locking cells only for certain users
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? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How can I protect cells and allow users to insert/delete | Excel Worksheet Functions | |||
Locking certain cells | Excel Discussion (Misc queries) | |||
locking cells based on results at runtime | Excel Worksheet Functions | |||
Help on locking cells | Excel Discussion (Misc queries) | |||
Locking a cell's format, but not value | Excel Discussion (Misc queries) |