If you don’t have access to the VBA code in the document, then contact the document author to have the code in the hidden module updated. This is the official workaround. If that does not help ...

After that, paste your macro code into this new module and save it using the dedicated option in the File menu. ... How to Insert a PDF File in an Excel Sheet. KomalSrivastava@TWC.