How to initiate code

[guestuser]

When I have edited links in a document, I want to activate a code. But it doesn’t activate.. what am I doing wrong??<?xml:namespace prefix = o ns = "urn:schemas-microsoft-comfficeffice" /><o></o>
It works if I go into the cell (F2), and then push enter.. (But I don't want the users to have to do that..)
<o></o>
<o>There might be many mistakes in this code.. I am a newbie..</o>
<o> </o>
<o></o>
Option Explicit<o></o>
<o> </o>
Private Sub Workbook_Open()<o></o>
'<o></o>
' Editlinks<o></o>
'<o></o>
Application.SendKeys ("%a")<o></o>
Application.SendKeys ("k")<o></o>
<o> </o>
End Sub<o></o>
<o> </o>
SO FAR IT WORKS FINE... <o></o>
<o> </o>
Private Sub Worksheet_Change(ByVal target As Range)<o></o>
<o> </o>
Dim cScreens As Object<o></o>
Dim cOptional_S_F As Object<o></o>
Dim yes As Boolean<o></o>
<o></o>
If Range("cScreens") = ("yes") Then Rows("34:51").Hidden = False Else Rows("34:51").Hidden = True<o></o>
If Range("cOptional_S_F") = ("yes") Then Rows("24:33").Hidden = False Else Rows("24:33").Hidden = True<o></o>
<o> </o>
End Sub<o></o>
<o> </o>
This last part doesn’t start on its own.. I think I need to initiate it somehow..?<o></o>

 

[guestuser]

I am sorry for going on about this, but it's really not working.. it just keeps showing the rows, even though the cell does not say 'yes' after I update the links

 

[RoryA]

Then either the code is in the wrong place, or you have disabled events. Open the VBEditor (Alt+f11) then press Ctrl+G to open the Immediate Window and type in:

Application.Enableevents = True

and then press Enter. Then try updating the links again.

 

[guestuser]

now I got it to work, but only with my old one.

Private Sub Worksheet_Calculate()
On Error Resume Next
Application.EnableEvents = False
If Range("cScreens") = ("yes") Then Rows("34:51").Hidden = False Else Rows("34:51").Hidden = True
If Range("cOptional_S_F") = ("yes") Then Rows("24:33").Hidden = False Else Rows("24:33").Hidden = True
Application.EnableEvents = True
End Sub

with the me.range, it kept the rows hidden when 'yes' was in the cell, and showed the rows when the cell was empty..

Thank you for all your help

 

[RoryA]

That doesn't really make sense since in a worksheet code module Range is the same as Me.Range, but as long as it's working, who cares.