Stop hyperlinks running when cells are locked

[nemmi69]

Searched the internet and not found an answer.

So I have a worksheet that is locked. To edit a row of information the user double clicks to run a user form. The problem is that the hyperlinks run still if the cell is the one double clicked. This can cause a permission error in the user form.

I have tried 'Cancel = True'

Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As Boolean)
Cancel = True

But they still run. Is there such a thing as on Hyperlink event do . . . ?

 

[nemmi69]

Well sort of fixed it by changing from Worksheet_BeforeDoubleClick to Worksheet_BeforeRightClick