Allow hyperlink editing in protected worksheet (2002)

[spburke]

Is there a way to allow a user to edit an inserted hyperlink in a protected worksheet? The cell that contains the hyperlink is unlocked. Thank you. -scott

[waveylines]

The hyperlink formula contains two parts:- e.g " =HYPERLINK(Sheet 1!$A$1,A1)" means that the actual hyperlink is taken from cell a1 in worksheet 1and the "friendly" name (the text that appears in the cell, is taken from cell a1 in the protected worksheet.

Therefore you could allow people to edit the cell in worksheet 1, whilst keeping your protected workksheet safe

Regards

Robert

[sdckapr]

You will have to either create a macro to first unprotect the sheet to allow editing then reprotect

or do as Robert suggested and place hyperlink formula in the cell (protect this cell) and have the "reference" to the link in another (unprotected cell) to allow editing.

Steve