I've added some code to combine several sheets into a single PDF, but this is causing all of my controls on my sheet to disappear after running the code. Checkboxes, Bevel shapes, command buttons...they all disappear after running the above code. I've commented out this section and the problem does not occur, but as soon as I uncomment this code and run my macro, all of my controls vanish. If I save and re-open the file, voila, my controls are magically back. Does anyone have ANY ideas as to what could be going on here?
A little more: it's the first line that's causing the issue. If I don't select an array of sheets, everything is fine. But if I select an array of sheets, all my control disappear after the PDF is created.
Bookmarks