Error 1004 - FollowHyperlink

[markw1804]

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

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

 

[ExcelGzh]

markw1804

If accessing the hyperlink directly on the spreadsheet works then that narrows the range of possible errors to between the label and the cell containing the hyperlink.

Is the label's macro pointing at this piece of code? If some copying and pasting from somewhere else has been done there may be another label on top of the original one linked to some code somewhere else which may be inaccessible. Try deleting the visible label to see if that reveals another label underneath. Ctrl-Z will reverse the deletion if there isn't a second label.

If the label has been copied maybe it has a different name (like lbl102_click) which has no defined click event.

The part of the code Worksheets("Stock") has no source workbook so the code just has to decide for itself which workbook the sheet "Stock" belongs to (usually the Active workbook). If somehow the workbook that this code is in is not the Active workbook then that would cause problems.

 

[markw1804]

Thank you for responding, I have double checked all your suggestions and as a last resort I recreated a new sheet and userform and getting the same error.
Must be something on the PC.

 

[ExcelGzh]

If clicking on the hyperlink directly on the sheet works then it is highly unlikely to be the PC.

Have you tried setting up a Watch window and examining the values of the various variables in the code? One of them will have an error value, it's just a question of finding which one.