Disable Read Only on All Workbooks

[bmkelly]

Hello,

I have a 'Master Macros' Excel file that opens upon Startup for Excel. Inside of this 'Master Macros' file contains macros that multiple individuals will be using, therefore I have the 'Master Macros' Workbook to be hidden in the background. When I open any excel workbook it will automatically open the Hidden 'Master Macros' Workbook however, if another individual were to open any excel workbook they therefor get the Read-Only error message so I was wondering if there is a way to disable the Read-Only prompt across all workbooks that individuals will be opening.

I have tried- Right Click Properties-Uncheck Read-Only on the Master Macros Workbook and it is indeed unchecked but individuals still get the Read-Only message.

I am not too entirely sure if this is something that can be done, but figured I would bring to discussion.

Thanks!

 

[Jaafar Tribak]

Try setting IgnoreRemoteRequests to FALSE when first opening the "Master Macros" workbook and see what happens.

Private Sub Workbook_Open()
    Application.IgnoreRemoteRequests = False
End Sub

 

[bmkelly]

I imported that code into a new module in the "Master Macros" Workbook and had my coworker attempt to open it to see if he would get the File In Use prompt and he did.

 

[Jaafar Tribak]

I imported that code into a new module in the "Master Macros" Workbook and had my coworker attempt to open it to see if he would get the File In Use prompt and he did.

View attachment 58593

No. You will need to place that code into the ThisWorkbook Module (Look for the module in the VBAProject window on the left side of the VB Editor. It is there by default). The code will take effect after re-opeing the workbook.

 

[Jaafar Tribak]

Deleted.

 

[bmkelly]

Deleted.

Sorry I was out for a bit there. I am assuming you are saying delete to you previous comment, because I only show Excel File Names for those that I have open in my VBAProject Menu. But your "ThisWorkbook" would be the same as my "Master Macros" which is where I had put it