OTOTO
Board Regular
- Joined
- Dec 23, 2013
- Messages
- 209
I have a protected sheet with double click event:
Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As Boolean)
If Target.Address Like "$N*" Then
currRow = Target.Cells(1, 1).row
Set currSheet = Target.Worksheet
Load frmform1
frmform1.Show
End If
End Sub
Double clicking opens up the form but it also opens up the following message box:
Exclamantion Pop Up Box: "The cell or chart that you are trying to change is protected and therefore read-only.
To modify a protected cell or chart, first remove protection....."
Is there a way to keep the sheet protected and eliminate this popup box from rearing its ugly head?
Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As Boolean)
If Target.Address Like "$N*" Then
currRow = Target.Cells(1, 1).row
Set currSheet = Target.Worksheet
Load frmform1
frmform1.Show
End If
End Sub
Double clicking opens up the form but it also opens up the following message box:
Exclamantion Pop Up Box: "The cell or chart that you are trying to change is protected and therefore read-only.
To modify a protected cell or chart, first remove protection....."
Is there a way to keep the sheet protected and eliminate this popup box from rearing its ugly head?