I have a workbook with several sheets. All of the sheets are the same structure.
I'd like to put a button on each sheet to print as noted below. I've tried but the button seems to be attached to only 1 specific sheet.
I need it to work on the ACTIVE sheet.

I need the print to be (a) landscape, (b) print the selection, and (c) fit to 1 page.

There are two selections that need to be printed. Each sheet is filtered and the blank rows removed in the filter.

The first range can be A1:L500 (500 is the bottom of the filter but there are usually only 20-30 rows max).
The second rage is M1:Y7

I know how to put the button on each sheet and associate it with the macro but need to have it work on all sheets with this same format/structure.