is there a way to make workbooks open as read-only but when a second person opens the same workbook the pop-up warning doesn't come up... it defaults to read-only?

I have a library.xlsm and a Macro.xlsm that open and hide every time excel opens, and it's does this for multiple users.. but I want to bypass that stupid warning popup when more than one person has excel open. I have a macro that forces the workbooks into read only, but i can't seem to get that warning to go away.