I have a macro that checks out a workbook on SharePoint, opens the workbook, makes changes, saves, closes, moves to next workbook and repeats the process.

When the SharePoint workbook that needs to be opened is already open with another user, the “workbook is locked for editing” prompt pops up. When this is the case I need my macro to elect not to continue opening the file.

I have attempted two workarounds but the prompt still appears:

1. Application.DisplayAlerts = False

2. Workbooks.Open(xlFile, , , , , , True, , , , False) [ignore read only and do not notify]

I’ve spent days trying to figure this out! ANY help appreciated!