nemmi69
Well-known Member
- Joined
- Mar 15, 2012
- Messages
- 938
- Office Version
- 365
- 2019
- 2016
- 2013
- Platform
- Windows
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'
But they still run. Is there such a thing as on Hyperlink event do . . . ?
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'
VBA Code:
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 . . . ?