Results 1 to 4 of 4

Command Button "Print Sheet" doesn't return selection

Threaded View

  1. #1
    Forum Contributor
    Join Date
    09-22-2013
    Location
    Sydney, Australia
    MS-Off Ver
    Office 2019
    Posts
    309

    Command Button "Print Sheet" doesn't return selection

    Hi

    I'm trying to get a print preview of a sheet selected from various data inputs.

    In the attached workbook Command Button labelled "PDF Single Sheet" launches Module D1_PDF_Single_Sheet and produces the required sheet as a PDF in the folder allocated to it.

    Command Button labelled "Print Single Sheet" launches Module D_SingleTeamSheetPrint but although using the same code to select the sheet to PDF, returns a Print Preview (as requested) but of the sheet the button is on (Race Meeting Information).

    Can anyone advise me as to why "Print Single Sheet" doesn't preview the selected sheet?

    The drop down at B18 on Sheet "Race Meeting Information" starts the sheet selection process taking information from the Sheet "Division Splits" and loads the relevant C2 sheet through Modules C, C2, C3 & C4. (Note: There are several modules that don't do anything in this workbook but are key in the real thing or work in progress!)

    Trust this is a clear enough explanation of what I'm after.

    Many thanks

    Frankie
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Add "comments" box pop up when the user "mouses over" an active-x command button.
    By mmcap64 in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 08-09-2020, 09:32 PM
  2. How to copy "command button" to another sheet
    By norika in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 01-31-2015, 01:47 PM
  3. Printing an area (A1:I272) on a different sheet than the "Print" button is on
    By cmsandiford in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 09-04-2014, 11:58 AM
  4. Adding "Command Button" and "Messages Box" in VBA Macro
    By sanjeevkumarmc in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 02-09-2014, 07:21 AM
  5. Create a Command Button to "Save As" and "Close" an Excel Workbook
    By thedunna in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 05-26-2013, 05:38 PM
  6. Command button "return" key
    By randell.graybill in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 06-05-2009, 03:58 AM
  7. How to change a Command Button caption from "Enable" to "Disable"?
    By Infinity in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 03-22-2007, 12:14 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