Results 1 to 14 of 14

Save, Print, and Delete on Command

Threaded View

  1. #1
    Registered User
    Join Date
    07-30-2020
    Location
    Charleston, SC
    MS-Off Ver
    Office 365
    Posts
    30

    Question Save, Print, and Delete on Command

    I need to work out a script that responds to a specific entry in column 1 on Sheet2, such as "Print"
    Once the command is entered, I need it to save the Print_Area as a PDF titled by Sheet2!R1C2 and print it to a certain network printer (Set as PC default), then delete the named cell range, "Worksheet"
    I have found bits and pieces of code that can accomplish this, but haven't been able to successfully piece them together. I am attaching a sample workbook for clarity. I'm fairly new to VBA, so I thoroughly appreciate any help you can provide on this!
    Attached Files Attached Files
    Last edited by singinwes; 08-18-2020 at 03:21 PM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Print # command to print copies & serialize
    By Dean Zuki in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 09-01-2016, 12:26 AM
  2. VBA code to create command button. Print all sheets then delete command button.
    By Declamatory in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 11-15-2015, 05:18 PM
  3. Save multiple sheet/print sheet with one command button
    By GJR in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 04-23-2014, 03:06 PM
  4. Macro Command Button: Combine Save As CSV and Delete Unsed Rows Macros
    By mustng_sally in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 04-15-2013, 10:41 AM
  5. Print Macro errors on final print command. Run-time error '1004':
    By Steverizer in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 02-05-2013, 06:41 PM
  6. [SOLVED] Change Print Command or add a new print command
    By Daniel R. Young in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 11-11-2005, 01:20 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1