View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 27,285
Default Why _Change(ByVal Target As Range)

Macros are disabled?

--
Regards,
Tom Ogilvy

"Jim at Eagle" wrote in message
...
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