Allow only one user to access workbook at a time

E

Emir_of_shmow

I need to set excel to allow only one user at a time to access a
workbook.
The workbook is NOT a shared workbook, but it resides on a network
share. Multiple users need to access it, but only One at a time. I
want all other users to get a message that the file is in use and they
can not open it.
Is this possible?
 
J

Jim

I believe that is the standard behavior of a network file that is not
shared; users who access the file when it is in use get a message the file
is in use and whether they want to open as Read Only.
 
Top