Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Single User Access
This is probably very simple, but i have a quick question. I have a spreadsheet on a public network drive. At the end of the day, people are to copy their information from their local machines to this public spreadsheet. How do I prevent 2 people accessing the file at the same time ie just prevent the update happening etc until it's 100% available? If a user opens a file which is already open (like by another user) then Excel will pop up a warning, and only allow the file to be opened read only. So what you actually have to do is work out how to coordinate everyone into opening the workbook at seperate times. Iain King |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Defining user access (via user id) using macros | Excel Discussion (Misc queries) | |||
Single cell access | Excel Discussion (Misc queries) | |||
Multiusers vs single user | Excel Discussion (Misc queries) | |||
Can more than one user open a single document? | Excel Discussion (Misc queries) | |||
User access to the VBE | Excel Programming |