在不允许用户选择锁定单元格的情况下，不能使用超链接来保护表

I have a worksheet that has a bunch of dynamic hyperlinks that change based on a drop down menu. Only the cells with drop down menus are unlocked. I have "select locked cells" unchecked so that when I protect the sheet, users can only select the drop down menus. Unfortunately, when I do this, the hyperlinks are no longer usable. I have a worksheet that has a bunch of dynamic