+ Reply to Thread
Results 1 to 4 of 4

Save Mult Sheets as 1 PDF - Sheets to be determined by user

  1. 10-08-2018, 03:26 PM #1
    EBrick
    EBrick is offline
    Registered User
    Join Date
    10-03-2018
    Location
    US
    MS-Off Ver
    2010
    Posts
    3

    Save Mult Sheets as 1 PDF - Sheets to be determined by user

    Hello,

    I'm trying to find a code that will save multiple different tabs as 1 PDF. The tabs to be saved will be indicated by the user of the document and will change ever time. I have already written a code for if someone checks the box to "Save With Full Document" - this results in column A of my last sheet to list out the different tabs to be saved as a PDF.

    I want to avoid defining a path for save location. I would like the value of cell D4 to be the name of the PDF when Saved.

    Can anyone help?
    Reply With QuoteRegister To Reply
  2. 10-08-2018, 03:53 PM #2
    Logit
    Logit is offline
    Forum Expert Logit's Avatar
    Join Date
    12-23-2012
    Location
    North Carolina
    MS-Off Ver
    Excel 2019 Professional Plus - 2007 Enterprise
    Posts
    7,014

    Re: Save Mult Sheets as 1 PDF - Sheets to be determined by user

    .
    Please Login or Register  to view this content.
    This path is hardcoded. You can change that to use the FileDialogSave so the user can select the location.
    Reply With QuoteRegister To Reply
  3. 10-08-2018, 04:08 PM #3
    EBrick
    EBrick is offline
    Registered User
    Join Date
    10-03-2018
    Location
    US
    MS-Off Ver
    2010
    Posts
    3

    Re: Save Mult Sheets as 1 PDF - Sheets to be determined by user

    Hi,

    Thanks for your reply. Is there a way to reference the names of the tabs to be saved by using a similar code to the below? The code below hid/unhid tabs based on a radio button selection. I'm hoping to apply the same flexibility here. People will be using check boxes to indicate with tabs will print.

    Please Login or Register  to view this content.
    Last edited by EBrick; 10-08-2018 at 04:59 PM.
    Reply With QuoteRegister To Reply
  4. 10-08-2018, 04:54 PM #4
    EBrick
    EBrick is offline
    Registered User
    Join Date
    10-03-2018
    Location
    US
    MS-Off Ver
    2010
    Posts
    3

    Re: Save Mult Sheets as 1 PDF - Sheets to be determined by user

    Omit this post
    Last edited by EBrick; 10-08-2018 at 04:58 PM.
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Sumif Across Mult Sheets
    By day92 in forum Excel General
    Replies: 5
    Last Post: 03-04-2016, 12:24 AM
  2. Press Save - Hide Sheets (before saving) - Actually Save - Unhide Sheets Again
    By MixedupExcel in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 02-28-2015, 07:22 AM
  3. [SOLVED] Sum Accross Mult Sheets
    By day92 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 02-26-2014, 04:10 PM
  4. [SOLVED] Refreshing/Recalculating Sheets based on user input or switching between sheets
    By SonOfOdin in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-24-2012, 09:48 PM
  5. Save as PDF and email / User defined Sheets and Print Areas
    By alexq in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 11-16-2010, 04:19 PM
  6. Pull information from different files with mult. sheets
    By Master.Ace in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 07-30-2009, 04:39 AM

Tags for this Thread

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1