+ Reply to Thread
Results 1 to 2 of 2

Exporting as PDF causing Shapes and Controls to disappear from sheet

  1. #1
    Forum Contributor
    Join Date
    07-26-2012
    Location
    USA
    MS-Off Ver
    Excel 2007 & 2010
    Posts
    351

    Exporting as PDF causing Shapes and Controls to disappear from sheet

    Please Login or Register  to view this content.
    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.
    Last edited by VBA FTW; 01-15-2014 at 01:04 PM.

  2. #2
    Forum Contributor
    Join Date
    07-26-2012
    Location
    USA
    MS-Off Ver
    Excel 2007 & 2010
    Posts
    351

    Re: Exporting as PDF causing Shapes and Controls to disappear from sheet

    I went ahead and just copied my array of sheets to a new workbook and exported to PDF from there, then closed the file without saving to get around this issue. Would love some feedback though as it's pretty strange behavior

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Make controls disappear when changing pages on Multipage - how?
    By TheLittlePrince in forum Excel Programming / VBA / Macros
    Replies: 12
    Last Post: 10-08-2013, 11:31 AM
  2. [SOLVED] What is causing ActiveX controls in my Excel file
    By welchs101 in forum Excel General
    Replies: 3
    Last Post: 05-16-2012, 12:09 PM
  3. [SOLVED] Controls on form disappear
    By jashburn13 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 06-27-2005, 03:05 AM
  4. Controls on form disappear
    By jashburn13 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 06-22-2005, 06:05 PM
  5. Shapes disappear from Excel 2000 to 2003?
    By Cheer in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 04-01-2005, 03:06 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1