| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
sharing workbook restrictions
How can I set a workbookit so that only the 1st user that opens the file can
make changes, all other people will get only read only access until that 1st person is finished. Thanks C |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
sharing workbook restrictions
Hi.
That is the default operation if you disable sharing. Even if the workbook isn't shared other users will be able to open, allbeit Read Only. -- Two heads are better than one! Email: subst1tut3 numb3rs for l3tt3rs... "Cheryl W" wrote: How can I set a workbookit so that only the 1st user that opens the file can make changes, all other people will get only read only access until that 1st person is finished. Thanks C |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
sharing workbook restrictions
Put the workbook on a shared folder and that's the way excel should treat the
updates. Although, the subsequent people will have to close and reopen the workbook to save their changes (after the first person saves and closes the workbook). Cheryl W wrote: How can I set a workbookit so that only the 1st user that opens the file can make changes, all other people will get only read only access until that 1st person is finished. Thanks C -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Sharing workbook, show last user change? | Excel Discussion (Misc queries) | |||
| Sharing Workbook and VBA | New Users to Excel | |||
| Workbook Sharing | Excel Worksheet Functions | |||
| Sharing a workbook | Excel Worksheet Functions | |||
| When sharing a workbook unable to change color of tabs | Excel Discussion (Misc queries) | |||
Linear Mode
