Thank you for the help.
I tried the above code but received an error.
Run-time error '1004':
Application-defined or object-defined error
Walking through the code, it seems to get through the If line but then generates the error.
I also realized I did not state that the hyperlink goes to a SharePoint file. I am not sure if that makes a difference.
Again, thank you for any help
Meijhana