View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
SIGE SIGE is offline
external usenet poster
 
Posts: 206
Default Outlines and Locked Worksheet: XL97

Hi There,

I have underneath sub to protect my locked cells ...
Standing on a locked cell prevents me to use (click) my outlines
(XL97!).

OK, I understand that it does ...what it does!

But maybe there is a workaround?
Best Regards Sige



Private Sub Worksheet_SelectionChange(ByVal Target As Excel.Range)
If Target.Locked = True Then
Me.Protect Password:=""
Else
Me.Unprotect Password:=""
End If
End Sub