I have a working, macro enabled Excel sheet on a SharePoint site for about 20 people to all use. I have it set so that it requires to be checked out in order to edit (So that only one person can edit at a time).
This has been working great, except some users of this file either ALWAYS forget to check the "check out and edit" option rather than "read only." So they will make changes in "Read Only" mode, and end up saving a copy of it on their own computers (because it wasn't checked out).
I was wondering if it were possible to make some sort of VBA event that checks to see if the document has been checked out of SharePoint before any changes are made, and if it hasn't, it shows a message box telling them so that they may close it out and re-open in "checked out" mode.