Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Limit similtaneous users of workbook
How do I prevent more than one person from opening a workbook at the same
time on a shared network drive? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Limit similtaneous users of workbook
As far a I know there is no way to do that without using VBA, and even with
that if the user decides to open with macro's disabled it will open anyway. But if a second user opens it while it's already open they should get the message telling them that 'This file is being edited by....'etc. Only the first user to open it can save any changes they made so it shouldn't really be a problem. Regards, Alan. "mekkor" wrote in message ... How do I prevent more than one person from opening a workbook at the same time on a shared network drive? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Limit similtaneous users of workbook
Do you mean two users able to read and write? Go to:
Tools-Share Workbook... Deselect the allow others... checkmark "mekkor" wrote: How do I prevent more than one person from opening a workbook at the same time on a shared network drive? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
LINKEDRANGE function - a complement to the PULL function (for getting values from a closed workbook) | Excel Worksheet Functions | |||
Multiple users / Shared workbook without interfernce? | Excel Discussion (Misc queries) | |||
How do i show other users that i am in a particular workbook | Excel Discussion (Misc queries) | |||
Multiple workbook user's with Master workbook - all password protected | Excel Discussion (Misc queries) | |||
How can I allow other users to make changes in a shared workbook | Excel Discussion (Misc queries) |