XLSM Sharing Question

[CarlH71]

Good Afternoon,

My question is related to an XLSM file that is shared on a network drive. I have built a Purchase Requisition form in vba that creates an auto-updated number. Currently when one user opens and starts to complete the form, another user can open and it would have the same number. When both users complete (submit) their form, the PR has the same number. Not the desired result as each should have a unique number.

I have checked and it is not being 'Shared'. Is there another way to limit the file to only allow one person at a time to open the workbook? Code that I can add?

Every solution I have seen so far indicates to turn off the sharing...does not apply in this case.

Thanks!

 

[mikerickson]

Could the auto number be generated at time of submission rather than at the start-up of the userform?
Could the Auto number generating code be modified to account for the pre-existing numbers AND the number of userform's currently open?