Hyperlink to workbook will not open when run as part of macro

Hello.

I have a hyperlink to a workbook set to open as part of a macro. When I run the macro the file never opens. Excel just pauses and shows the hourglass and then it goes away. If I click the hyperlink, the linked workbook opens just fine.

If I set the hyperlink to open a word doc and then run the macro it opens the word doc just fine.

Could this be an excel setting?

It has been very frustrating, any help would be appreciated.

The code I used to open the hyperlink is:

Sub Macro1()
'
' Macro1 Macro
'

'
    Range("C18").Select
    Selection.Hyperlinks(1).Follow NewWindow:=False, AddHistory:=True
End Sub