Copy data and Error

Hi,

I wonder if someone could please guide me - I'm using the following Macro coding to copy data from one workbook to another - however the another workbook is shared across different campuses so if any other use in that workbook then the error message comes up. What I'm looking for is - if someone is in the other workbook then user receives the message pop up to say "Another user is in the workbook, would you like to save or wait" - If user select save then it saves as normal and if click retry and try again to copy the data over to another workbook and then save. Here's my current coding.

Many thanks in advance.

Please Login or Register  to view this content.