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>
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>