Userform - Shared Wookbook - Error

[phendrena]

Hi there,

I have a workbook(s) setup as shared.
As this workbook is shared and is being used by several people there are occasions when and error occurs when trying to save it - "File locked for saving".

In order to avoid conflicting cell errors I have the form save when it is opened and save before and after the data is sent from the userform to the worksheet.

If the error occurs before the data is submitted to the worksheet then the data is lost. How can i avoid this from happening? Is there a better way to avoid conflicting errors than saving the workbook several times?

Thanks,

[Demosthine]

Good Evening.

You could use an ErrorHandler for this. When the script Errors with "File locked for Saving." have it go to ErrHandler.

In your ErrHandler region, set it up to wait X amount of seconds and then Resume. It will resume at the last line that errored out.

Hope this idea helps.
Scott