I have a workbook with different worksheets of different sizes. I want to place a print button on every worksheets so that upon clicking it a macro will run and automatically select some particular predefined custom size pages in printer page setup dialog box and print it.

there are two different custom size papers - 1) ubi
2) sbi

please help me with the vb code for the macro.

Thanks