I want Excel 365 to lock the file when in use

[AgentMeow99]

This is causing huge problems in my office and I've tried to find a solution to no avail - so here I am...

We are using office 365 with auto-save off for our check register in Excel, when I am in the file and someone else opens it Excel wants me to save a copy or discard changes. I remember back in the day when we used excel on our local server it would not allow you to open the file or it would give you the option to open read only. Is there anyway to turn this on in 365?

 

[sijpie]

this might help

https://stackoverflow.com/questions/20822361/how-to-lock-a-file-for-editing-using-vba

 

[AgentMeow99]

THANK YOU SO MUCH!!! It worked