I made a Excel s[read sheet with about 50 worksheets, each represents a author. Sheet 2 has a PDF embedded with synopsis for a number of books. I wanted a button on each worksheet that when clicked it would refer back to sheet 2 and open the PDF. The code I made is :
Sub OpenPdf()
'
' OpenPDF Macro
'
'
Sheets("Synopsis").Select
ActiveSheet.Shapes.Range(Array("Object 3")).Select
Selection.Verb Verb:=xlPrimary
End Sub
This works fine. The problem is the PDF opens in the background. Is there a way to add or modify in order to resolve the open in background issue.
Thanks
JIm
Sub OpenPdf()
'
' OpenPDF Macro
'
'
Sheets("Synopsis").Select
ActiveSheet.Shapes.Range(Array("Object 3")).Select
Selection.Verb Verb:=xlPrimary
End Sub
This works fine. The problem is the PDF opens in the background. Is there a way to add or modify in order to resolve the open in background issue.
Thanks
JIm