Morning All,
A real strange one that I cant work out, this code has been working without issue from a label click on a userform which opens a hyperlink to an image stored on a shared drive. It just stopped working yesterday.
I am getting the 1004 runtime error - Application defined or object defined error
I have checked the current row is correct and the hyperlink is in column 34
When I click on the hyperlink from the spreadsheet it works no problem. I tried removing and re-adding the hyperlink as well.
Any pointers would be much appreciated,
Mark
A real strange one that I cant work out, this code has been working without issue from a label click on a userform which opens a hyperlink to an image stored on a shared drive. It just stopped working yesterday.
I am getting the 1004 runtime error - Application defined or object defined error
VBA Code:
Private Sub lblAddDrawing1_Click()
ActiveWorkbook.FollowHyperlink Worksheets("Stock").Range(CurrentRow + 2, 34).Value, NewWindow:=True
End Sub
I have checked the current row is correct and the hyperlink is in column 34
When I click on the hyperlink from the spreadsheet it works no problem. I tried removing and re-adding the hyperlink as well.
Any pointers would be much appreciated,
Mark