+ Reply to Thread
Results 1 to 5 of 5

Create a Print Button (PDF)

  1. #1
    Registered User
    Join Date
    12-10-2014
    Location
    Dallas,TX
    MS-Off Ver
    2010
    Posts
    10

    Question Create a Print Button (PDF)

    Hi All,

    I'm new to this forum. Need help..I'm working on Excel spreadsheet (invoice) and I would like to add a button to save and print the invoice into a PDF.. I've been in youtube but I'm getting to much information..
    All I need is to click the button to creat PDF.

  2. #2
    Forum Moderator davesexcel's Avatar
    Join Date
    02-19-2006
    Location
    Regina
    MS-Off Ver
    MS 365
    Posts
    13,474

    Re: Create a Print Button (PDF)

    You can probably use your macro recorder to saveas pdf, then assign the code to a button. In your next post, post the code from the macro recorder if you need it edited.

  3. #3
    Forum Expert newdoverman's Avatar
    Join Date
    02-07-2013
    Location
    Port Dover, Ontario, Canada
    MS-Off Ver
    2010
    Posts
    10,330

    Re: Create a Print Button (PDF)

    I have done this before and davesexcel is correct. You can record a macro to do this.

    If the invoices are always the same cell range, set the print area as the first step. If the data range varies use Ctrl+* to select the active area then set the print area. Then follow the process that you would do manually.

    Create a button (Developer Tab/Insert) and assign the macro to it.
    <---------If you like someone's answer, click the star to the left of one of their posts to give them a reputation point for that answer.
    Ron W

  4. #4
    Registered User
    Join Date
    12-10-2014
    Location
    Dallas,TX
    MS-Off Ver
    2010
    Posts
    10

    Re: Create a Print Button (PDF)

    Is there a Code in "HOW TO" DO this???? I've created the spread sheet but I need the button, this form will be used for people that can't browse at all.. The button will be easy for them.. however, I'm not geting the feed back I'm looking for.. HOW DO I create this button.. Step by step instructions... How about some code??

  5. #5
    Forum Moderator davesexcel's Avatar
    Join Date
    02-19-2006
    Location
    Regina
    MS-Off Ver
    MS 365
    Posts
    13,474

    Re: Create a Print Button (PDF)

    You have been told you how to get the code, use your macro recorder.
    Check here how to record a macro. https://youtu.be/huNEHBr60cc

    The general purpose for this forum is to help people with excel problems, if you are a 1st time user, you can do a web search such as "Excel macro Tutorials" to learn the basics of excel vba.

+ 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. Create a button for print
    By Shakeelqamar in forum Excel - New Users/Basics
    Replies: 5
    Last Post: 05-08-2008, 10:29 PM
  2. Create a button to print a sheet
    By skylinekiller in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 01-12-2008, 12:14 PM
  3. how can a create a print command button in excel
    By velcrowe11 in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 05-12-2006, 11:39 AM
  4. [SOLVED] Create a Button that will print sheets
    By Helen in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 11-14-2005, 10:10 PM
  5. How do I create a print button?
    By Dan in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 04-28-2005, 11: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