ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Hyprtlink to protected worksheet (https://www.excelbanter.com/excel-worksheet-functions/19093-hyprtlink-protected-worksheet.html)

whouser

Hyprtlink to protected worksheet
 
I have a workbook with five worksheets. I want to hyperlink to specific cells
in each sheet from the first sheet in the workbook. I also want all sheets to
be protected. When I protect the sheets, the hyperlink always goes to the
first cell on the sheet. When I unprotect the sheets, the hyperlinks work
fine. How can I hyperlink to specific cell locations on a protected sheet?


All times are GMT +1. The time now is 05:54 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com