Hyperlink Column after macro paste using a worksheet event
up vote
0
down vote
favorite
Sorry, change of question, I was able to fix the macro error, was a stupid rookie mistake, worksheet was protected.
Update on the question, I have used the hyperlink macro to create the below worksheet event which fires after a number of rows (varies) are pasted (values only because other worksheet is using cell references) from another worksheet. It worked for 2 or 3 times then just stopped, any idea why?
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
Dim lRow As Long
Worksheets("HW Orders").Unprotect
If Intersect(Target, Range("S:S")) Is Nothing Then Exit Sub
Select Case Target.Address
Case "S:S"
With ActiveSheet
lRow = .Range("s" & .Rows.Count).End(xlUp).Row
For Each c In .Range("s2:s" & lRow)
ActiveSheet.Hyperlinks.Add anchor:=c, Address:=c.Value
Next
End With
End Select
Worksheets("HW Orders").Protect
End Sub
hyperlink events
add a comment |
up vote
0
down vote
favorite
Sorry, change of question, I was able to fix the macro error, was a stupid rookie mistake, worksheet was protected.
Update on the question, I have used the hyperlink macro to create the below worksheet event which fires after a number of rows (varies) are pasted (values only because other worksheet is using cell references) from another worksheet. It worked for 2 or 3 times then just stopped, any idea why?
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
Dim lRow As Long
Worksheets("HW Orders").Unprotect
If Intersect(Target, Range("S:S")) Is Nothing Then Exit Sub
Select Case Target.Address
Case "S:S"
With ActiveSheet
lRow = .Range("s" & .Rows.Count).End(xlUp).Row
For Each c In .Range("s2:s" & lRow)
ActiveSheet.Hyperlinks.Add anchor:=c, Address:=c.Value
Next
End With
End Select
Worksheets("HW Orders").Protect
End Sub
hyperlink events
add a comment |
up vote
0
down vote
favorite
up vote
0
down vote
favorite
Sorry, change of question, I was able to fix the macro error, was a stupid rookie mistake, worksheet was protected.
Update on the question, I have used the hyperlink macro to create the below worksheet event which fires after a number of rows (varies) are pasted (values only because other worksheet is using cell references) from another worksheet. It worked for 2 or 3 times then just stopped, any idea why?
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
Dim lRow As Long
Worksheets("HW Orders").Unprotect
If Intersect(Target, Range("S:S")) Is Nothing Then Exit Sub
Select Case Target.Address
Case "S:S"
With ActiveSheet
lRow = .Range("s" & .Rows.Count).End(xlUp).Row
For Each c In .Range("s2:s" & lRow)
ActiveSheet.Hyperlinks.Add anchor:=c, Address:=c.Value
Next
End With
End Select
Worksheets("HW Orders").Protect
End Sub
hyperlink events
Sorry, change of question, I was able to fix the macro error, was a stupid rookie mistake, worksheet was protected.
Update on the question, I have used the hyperlink macro to create the below worksheet event which fires after a number of rows (varies) are pasted (values only because other worksheet is using cell references) from another worksheet. It worked for 2 or 3 times then just stopped, any idea why?
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
Dim lRow As Long
Worksheets("HW Orders").Unprotect
If Intersect(Target, Range("S:S")) Is Nothing Then Exit Sub
Select Case Target.Address
Case "S:S"
With ActiveSheet
lRow = .Range("s" & .Rows.Count).End(xlUp).Row
For Each c In .Range("s2:s" & lRow)
ActiveSheet.Hyperlinks.Add anchor:=c, Address:=c.Value
Next
End With
End Select
Worksheets("HW Orders").Protect
End Sub
hyperlink events
hyperlink events
edited Nov 23 at 19:53
asked Nov 23 at 19:10
iggypop
12
12
add a comment |
add a comment |
active
oldest
votes
active
oldest
votes
active
oldest
votes
active
oldest
votes
active
oldest
votes
Thanks for contributing an answer to Super User!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Some of your past answers have not been well-received, and you're in danger of being blocked from answering.
Please pay close attention to the following guidance:
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fsuperuser.com%2fquestions%2f1377877%2fhyperlink-column-after-macro-paste-using-a-worksheet-event%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown