| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Workbook working on by two people
Is there a way to have a workbook open where two people can work on it? And
also, is there a way to setup rights where one person could only work in column A,B,C, D, and the other person work in E,F,G,H? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Workbook working on by two people
Yes to both.
Under Tools-Protection, Allow Users to Edit Ranges Setup the appropriate ranges for the correct users, setting up any additional options as desired. Then, again under Tools-Protection, choose: Protect & Share Workbook. Multiple people can now have the workbook open and work on it, and because you protected it, only the defined users can work in their respective cells. -- Best Regards, Luke M *Remember to click "yes" if this post helped you!* "Pammy" wrote: Is there a way to have a workbook open where two people can work on it? And also, is there a way to setup rights where one person could only work in column A,B,C, D, and the other person work in E,F,G,H? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Maximize workbook not working | Excel Discussion (Misc queries) | |||
| working with data in the same workbook? | Excel Discussion (Misc queries) | |||
| workbook linking cells not working within a workbook | Excel Discussion (Misc queries) | |||
| how do i count how many people are working between two times in e | Excel Worksheet Functions | |||
| Often-Used Code not working in a new Workbook | Excel Discussion (Misc queries) | |||
Linear Mode
