I'm trying to get the following code to work properly... I'm sure I'm missing something silly
Private Sub CommandButton1_Click()
ActiveWorkbook.FollowHyperlink Address:="http://www.thisplace.doc", NewWindow:=True
End Sub
When click, and I get the following "Some files contain viruses...etc." When "OK"ed it download document properly. When Cancelled Run time error '287' to debug. I do not think users will always 'ok', so it's a big problem and i'm stumped! When cancelled it should just return to ActiveSheet. I'd prefer if I could have no pop ups at all, just the document. Can someone help please?? Thank you!
Bookmarks