View Single Post
  #1   Report Post  
k-ham
 
Posts: n/a
Default restrict opening Excel file residing on a shared drive to one user

Excell 2000 - I have a worksheet that performs certain functions and then
saves the file when the workbook is opened. Can I restrict opening this
workbook which is on a shared drive to one user at a time. I do not need a
"read-only" option because the second person opening the workbook in "read
only" would encounter an error due to the automatic saving of the file.