I currently have a workbook which is protected along with all the
worksheets. Certain cells are unprotected to allow users to enter data.

Certain users will be required to edit/change links to other workbooks.
The cells containing the links are not individually protected. However,
Excel will not allow users to edit or change the external links when
protection to the workbook/sheets is enabled. It is essential to
maintain the integrity of the workbook and sheets and therefore issuing
a password to users is not an option.

Is there a method where a user can run a macro which temporarily
removes the protection, brings up the edit/change links interface so
that the user can edit these and then the macro protects the
workbook/sheets once again before exiting the macro? The user must have
the ability to navigate in the interface window to change/edit these
links and the macro must NOT allow users to exit before protection is
replaced and must not be able to enter into any other form of editing
during the macro.

Please can anyone help????