Macro that selects read only any time excel opens

[Magoosball]

I have moved my excel personal macro workbook to a shared drive and have created a shortcut into the XLSTART folder for everyone on my team. This way whenever I update one of my macros it updates everyone on my teams at the same time across multiple computers.

I am running into a problem because anyone who opens excel is getting the message box that states the workbook is currently open by another user would you like to continue as read only.

Is it possible to write a script that will automatically select read only on the personal workbook whenever excel is opened up and this message box appears?


Thank you in advance!

 

[gruntingmonkey]

Have you tried the following:

Application.DisplayAlerts = False

Remember to set it to true after the file opens though.

 

[Magoosball]

How would I make sure that this script fires anytime excel is opened? The read only message box appears the moment excel is opened.

 

[gruntingmonkey]

In VBA, where it says ThisWorkbook, use the following:

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

 

[Magoosball]

I am still getting this message box when excel opens. Not sure what I could be doing wrong

 

[gruntingmonkey]

Can you post your code? And where it is?