Changing links when protected
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???? |
Changing links when protected
Also,
It could not hurt to have error handling that proects it if any error occurs while running the macro. |
All times are GMT +1. The time now is 08:51 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com