ExcelBanter - How do i allow users to insert hyperlinks into a protected sheet

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - How do i allow users to insert hyperlinks into a protected sheet (https://www.excelbanter.com/excel-discussion-misc-queries/97797-how-do-i-allow-users-insert-hyperlinks-into-protected-sheet.html)

Andy

How do i allow users to insert hyperlinks into a protected sheet

I am using Excel 2000 and want to allow users to insert a hyperlink into a
unprotected cell in a worksheet that has been protected, however the
hyperlink option is grayed out when the sheet is protected.

All times are GMT +1. The time now is 02:59 PM.