Apollo4life
New Member
- Joined
- Sep 25, 2014
- Messages
- 37
Hello,
I have a macro that that fills out a template with textboxes and cells, then it prints to PDF via ExportAsFixeddFormat. It works great on the first run (creates 31 seperate PDFs each run), then on the second run (exact same data), it seems to be running great and bam after roughly 4 PDFs it fails (no error code) and rapidly runs through the process (with only 4 PDFs created) with my machine beeping mysteriously each time and "This picture can not be displayed over the textboxes/buttons" (photos attached). Code below is what I have tried to prevent it, but it does not work. If I close the workbook and reopen and run again, there are no issues.
I have a macro that that fills out a template with textboxes and cells, then it prints to PDF via ExportAsFixeddFormat. It works great on the first run (creates 31 seperate PDFs each run), then on the second run (exact same data), it seems to be running great and bam after roughly 4 PDFs it fails (no error code) and rapidly runs through the process (with only 4 PDFs created) with my machine beeping mysteriously each time and "This picture can not be displayed over the textboxes/buttons" (photos attached). Code below is what I have tried to prevent it, but it does not work. If I close the workbook and reopen and run again, there are no issues.
Code:
Application.CutCopyMode = False
