View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Jim at Eagle Jim at Eagle is offline
external usenet poster
 
Posts: 83
Default Why _Change(ByVal Target As Range)

Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Address = "$D$9" Then LTVisable
End Sub
This used to work. Now it won't. No protection, ScreenUpdating = True,
LTVisable works, even substituted something simple, still won't fire.
Tried to use on other worksheets within workbook, still won't fire.
Open new workbook, OK that works.
Why won't this work?

--
Jim at Eagle