Command Button "Print Sheet" doesn't return selection

[Frankie_The_Flyer]

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

[rollis13]

You are using a method name ( .PrintPreview ) as macro name ( Sub PrintPreview () ) in module D_SingleTeamSheetPrint which isn't allowed.
Change the name of the macro to ex. MyPrintPreview and change the Call in Sheet1's module.

[Frankie_The_Flyer]

Excellent!! Many thanks rollis13. Just the job!!

[rollis13]

Thanks for the positive feedback , glad having been of some help.