Hi all, I'm trying to lock down table edits but need to allow sorting AND executable hyperlinks..
Please help, can't find a solution that works for both.
'Allow Users to Edit Ranges' + all cells locked -> allows sorting but can't click the cells with hyperlinks
'Allow Users to Edit Ranges' + only columns with hyperlinks unlocked -> allows sorting and clickable hyperlinks but 'last active' hyperlink is executed continuously when clicking anywhere else on the screen that contains locked cells
All cells locked + 'select locked cells' -> hyperlinks work but can't sort
Please help, can't find a solution that works for both.
'Allow Users to Edit Ranges' + all cells locked -> allows sorting but can't click the cells with hyperlinks
'Allow Users to Edit Ranges' + only columns with hyperlinks unlocked -> allows sorting and clickable hyperlinks but 'last active' hyperlink is executed continuously when clicking anywhere else on the screen that contains locked cells
All cells locked + 'select locked cells' -> hyperlinks work but can't sort
