+ Reply to Thread
Results 1 to 2 of 2

VBA Print help

  1. #1
    Forum Contributor
    Join Date
    12-14-2005
    Location
    US
    MS-Off Ver
    Excel 2019, Excel 365, Excel Mobile (Android)
    Posts
    145

    VBA Print help

    I have attached a workbook for reference. The code below works, but I cannot run the code from a button on the TABLES worksheet. When run it prints the TABLES worksheet and not the REPORT worksheet. If I enter the information on the tables worksheet and then go to the report worksheet and run the macro it works. So what code should be added so that I can just click on the Print Form button and the macro will run printing the report?

    Thank you for all for any help.

    Please Login or Register  to view this content.
    Attached Files Attached Files

  2. #2
    Forum Expert
    Join Date
    08-17-2007
    Location
    Poland
    Posts
    2,244

    Re: VBA Print help

    Replace
    Please Login or Register  to view this content.
    with
    Please Login or Register  to view this content.
    Artik

+ 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. ignore margin print area warning when printing from normal print menu
    By nigelog in forum Word Formatting & General
    Replies: 1
    Last Post: 09-21-2018, 05:48 PM
  2. Print until a specified point, print a pdf then print from excel again
    By orkula in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 08-18-2017, 10:17 AM
  3. Replies: 2
    Last Post: 08-29-2016, 01:36 PM
  4. Disabled print toolbar and menu but Print Macro button cannot print also...
    By zein97 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 09-22-2014, 01:42 PM
  5. Set print area of selected range then print preview if ok then print the document!
    By HaroonSid in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-01-2014, 07:10 AM
  6. 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
  7. VBA to set print range, open box asking for print qty, print, then redefine print area
    By galvinpaddy in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 07-11-2012, 06:43 PM

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