VBA Code to link macro-enabled workbook

Hi All

Me again. I have the following code which links my invoice No in Column a with a pdf of the same name. How can I add to the code which will allow for me to link a SheetName in column B with the macro enabled Sheet with the same name.

Sheet name is "Steven1" and Column B Cell value = "Steven1"
Public FoundIt As Boolean, Inv As Range

Please Login or Register  to view this content.

Sorry, got it. So simple.
Changed

Please Login or Register  to view this content.

to

Please Login or Register  to view this content.

And added extra line of code to include xlsm.doc

Please Login or Register  to view this content.

Please Login or Register  to view this content.