Selected Answer
Leopard
In the modified file attached, I've used the Adobe Reader to open a file at a given page, rather than IE.
Module1 has this code but you may need to change the executable location and will need to change the file string (which follow the bits in bold):
Sub PageInPDF()
Dim File As String, Reader As String, Pg As String
Reader = "C:\Program Files (x86)\Adobe\Acrobat Reader DC\Reader\AcroRd32.exe"
File = "E:\Documents\ATEN cs682 KVM Switch manual_s-2014-10-31.pdf"
'File = ThisWorkbook.Sheets(1).Range("C9").Value ' use this if cell has file path but NO hyperlink
Pg = "page=" & InputBox("Enter the page number")
r = Shell(Reader & " /a " & Chr(34) & Pg & Chr(34) & ", " & Chr(34) & File & Chr(34), 1)
End Sub
Note that you'll need to run this from the Module for now but you could call it from an event macro
Private Sub Worksheet_ChangeSelection... say (rather than
Worksheet_FollowHyperlink)
The command line syntax (following the Shell command) is demanding so be sure to leave in the Chr(34) references- these add an inverted comma so you get text like "page=3" which is needed.
You'll see above that I have a line commented out (starting 'File = ...) where I had problems opening the hyperlinks from the worksheet- I think this is related to the hyperlink replacing spaces with %20 (like URLs) but my file name included spaces. If you're happy to paste only the file path and full name into the cell as text (e.g. 'E:\Documents\... in my case) but NOT a clickable hyperlink (like cell C5), then that line works and the file opens at the desired page.
Hope this is some help to you.