VBA - allow concurrent change for shared workbook

[logstarter]

Hi,

I have a VBA program to mark the application no which is generated sequentially. There are multiple worksheets for different types of application. The workbook is shared to be updated by a group of people. The sequential no is a counter stored in one of the worksheet, counting no of application generated each day.

For example, I have app A and app B worksheet. When student A generates the first app no in worksheet "app A", the app no generated will be 19041000001, afterwards, if student B generates another app no in worksheet "app B", the app no generated will be 19041000002 and so on.

My problem is that since it's a shared workbook. When student A and student B opens the file to update, the counter is showing the same sequential no, and if they make the update concurrently, they will get the same app no.

I would like to ask if there are anyway to update the workbook simultaneously? or is there any way to notify the another user that someone is updating the log?

Thank you.

 

[logstarter]

I am thinking if I refresh the workbook before assigning the application no, will it be a good approach

[COLOR=#242729][FONT=Consolas]ActiveWorkbook.RefreshAll
[/FONT][/COLOR]