Results 1 to 1 of 1
Thread: Print Macro for several sheets
2015-10-29, 01:18 #1
- Join Date
- Jan 2001
- La Jolla, CA
- Thanked 67 Times in 63 Posts
Print Macro for several sheets
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.