Need help forming specific search terms

[TorontoJim]

Good Morning,

I'm willing to do the research work on what I want to achieve but am not sure how to phrase the search terms (after half an hour of useless results).

I want to have a workbook that can be opened by only one person at a time, on a network drive.

I've tried search terms:

"excel vba one person at a time"
"excel vba limit to one person"
excel vba limit users"

nothing seems to be coming close to anything relevant. Can anyone who has done this help with better search terms or point me to a site I can specifically search for this topic? No results here on mrexcel.com that were germain.

Thank you for your time,
Jim

 

[RoryA]

That is the way Excel should work by default. Anyone who subsequently opens the file will be told they can only open it read-only and choose whether or not to be notified when it is available for editing.

 

[TorontoJim]

DOH!

Thanks **sheepishly slinks away**