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 ...

1. Open your Excel workbook containing the data to be formatted. 2. Access the Visual Basic for Applications (VBA) editor, typically by pressing Alt + F11. 3. Insert a new module in the VBA editor. 4.

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.