Microsoft Excel Alert when saving file on shared network

[sspatriots]

I get a message that says "Someone else is working in "Network Path and filename" right now. Please Try again later." about every 4th time I save my file that is on a shared network. Nobody else is in the file, but I still get the message 25% of the time. What would cause that if I'm the only one in the file?

Also, it happens when I have my code running that saves the workbook as well. Is there a way to make that alert not show up? my code around the save command is shown below, yet the alert still shows up. I have an error handler in the code right now to loop back and try again if the user selects "Yes" in the message box.

With Application
    .DisplayAlerts = False                'Turns off alerts
    .AlertBeforeOverwriting = False       'Turns off overwrite alerts
    .ScreenUpdating = False               'Turns off screen updating
End With

    ThisWorkbook.Save


With Application
    .DisplayAlerts = True                 'Turns back on alerts
    .AlertBeforeOverwriting = True        'Turns on Overwrite alerts
    .ScreenUpdating = True                'Turns on screen updating
End With

Please advise, SS

 

[Shiseiji]

Try

Application.EnableEvents = False

And see Chip Pearson's article on why you need to

Application.EnableEvents = True

Ron

 

[sspatriots]

Not sure how I missed your response. I just tried it and it worked great. thank you

 

[Shiseiji]

Not sure how I missed your response. I just tried it and it worked great. thank you

Glad I could help.