VBA Print buttons

[oo0tommyk0oo]

Hi,

I am not sure if this is possible but I would like to create two print buttons on my spreadsheet. I currently have a dynamic named range to select my print_area which works well. But i would like to use VBA to be able to print certain columns with the click of a button.

1 button to print all dynamic range and 1 button to print columns A:G and K:P

I have attached an example. Is this possible?

Thank you for any help

Tommy

[davesexcel]

Try using your macro recorder.
Hide the columns you don't want printed. Then print, and unhide the columns.

[oo0tommyk0oo]

Will give that a try

Thanks