I am very new to marcos and am having trouble.

As part of a macro I was working on, I wanted to open the hyperlink of a selected cell (contains link to another workbook.) I had it all working nicely, I saved it and closed it. When I reopened it the hyperlink macro will not work right.

When I run the macro it gives me the usual warning to make sure the link is from a trustworthy source, and asks if Id like to open the file. I click ok, then the hourglass comes up for a few seconds and then it goes away. Nothing happens though, the file does not open.

But, If I click the actual cell that contains the hyperlink, it gives me the warning, I click ok, and then the file opens. Its frustrating that it worked before I saved and closed it.

I even made a new file and just set up the hyperlink macro part, but it still will not work. Am I missing something? Thanks for any help.

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