VBA to stop user from following hyperlink if someone is editing a page

[kje11]

Hello, I have a main home tab that has a couple links via FollowHyperlink which copies information from the home tab and then activates another tab and pastes info over.
From there, the user would be filling out additional information on the new tab which could take some time.

So, while the user is filling in the additional information, I want to block any of the hyperlinks on the home page and possibly put up an error box saying someone is actively updating the new tab, please try again later.
Trying to stop any overwriting as someone is actively updating the sheet. Is there any sort of VBA code to include?

 

[bobsan42]

Is it a shared workbook?
The simplest is to write a value in a cell somewhere to mark editing process.
But whatever you do it is a complicated thing to track and tedious to maintain. There are too many variables and uncertainties.
Someone may take a day to fill a simple form - you can't block all other users.
Another option is to create a new sheet with a form when someone needs it then delete it after data is saved. In this case your main problem will be to prevent two saves at the same time.