To be honest, I don't have any experience working with SharePoint. My idea was to insert a Workbook_Open event into the code module for ThisWorkbook in the child files so that when each file was opened, it would also open the Master.