You kind folk from MrExcel helped me to design a brilliant Order Number Sheet which between 3 users we can tick each O/N off using macros.
This has helped us greatly. However the file is currently on a shared googledrive - the only problem is that we can all access the file at the same time and we have been generating duplicate orders.
I wondered whether there was something i could do to the excel sheet to only allow one user in at a time regardless of the file being on googledrive.
My personal thoughts are that this might be tricky but would aprreciate someones help/advice if possible.
This has helped us greatly. However the file is currently on a shared googledrive - the only problem is that we can all access the file at the same time and we have been generating duplicate orders.
I wondered whether there was something i could do to the excel sheet to only allow one user in at a time regardless of the file being on googledrive.
My personal thoughts are that this might be tricky but would aprreciate someones help/advice if possible.