Our team is looking for a way to collaborate on a singleExcel document. We need to be able tolock certain portions so that only a few have access and leave others open sothat anyone can edit. We also need a wayfor the document to email a daily change log (possibly only for specificchanges) so we know what changes were made, who made them, and when. I’m thinking the last part will probably needto be VBA Code?


We were thinking SharePoint or some similar platform. Google Docs is out as our company won’t allowaccess to it. We do have common folderswhere we could keep it that everyone can access.

We will also be using this file to pull the data into alarger file using VBA (the code is in the other file).

Just trying to figure out the best method atthis point and see if there is even a way to make this happen. Any suggestions are greatly appreciated.