View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
[email protected] robertp@profund.com is offline
external usenet poster
 
Posts: 4
Default Replace Excel Message w/Custom Message

Try this. I think It's what you want, well I hope so anyway!

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
If Target.Locked = True Then
MsgBox "My Message", vbInformation, "My Message"
End If
End Sub