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
Bookmarks