phendrena
11-07-2008, 06:14 AM
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,
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,