Hi all,

I'm sure this has probably been asked already but I couldn't find a thread so apologies!

I have around 7 PFD's embedded into my Excel 2010 workbook on individual tabs. I have a "Main Page" where I have created 7 buttons. I have coded them so that when you select a button, the PDF linked to that button automatically opens. I am not great with coding so I have just used the "record macro" method.

This works for most of them, but for some reason a few are failing. The coding says it's a fail on "Selection.Verb Verb:=xlPrimary" which all the others have, so I am a little confused.

Please could someone advise or offer a simple coding that I can use. The PDF files are all embedded, so it's simply:

-Click button (on Main Page)
-Go to Sheet that file is embedded
-Open Embedded file
-Return to Main Page

Many thanks in advance!