Hello. So I'm trying to add a button feature where the user can click on a button and it will open the particular data sheet (for that part number) in a web browser via a hyper link. The Part number is determined by a drop down menu which will update the active workbook/sheet with data from that specific part number's workbook. I'm going to store the web address for the hyper link in that part number's workbook, and update a cell in the "active workbook" with the following code 

Please Login or Register  to view this content.
Now I got a macro when the button is pressed

Please Login or Register  to view this content.
I'm getting the error

ExcelError.JPG

So my question is really how should I resolve this error with the hyperlinks not working. I know I'm kinda making this work in a round about way buy getting the data from one workbook to the next, first and then having the button macro working of the cell in the active work book. But I was having a hard time "getting it to work" the more straight forward way.