VBA Printing

[jondallimore]

Hello everyone,

I am looking to put a Print button onto a worksheet for people who panic when they have to do anything this complicated in Excel.

The button must:

1) Select a range of cells, say A1:Z99
2) Open the usual Excel 2010 print menu screen(So that they can manually select colour or black and white printing)
3) Set the printout to Print Selection.

They can press Print manually, Im not going to do everything for them!!

I could use it to select colour printing too, but I suspect this would depend on the printer being used and wouldnt work with all printers - unless anyone knows different? Probably more trouble than its worth though.

Any help gratefully received, and may result in chocolate biscuits if you live near me

Thanks
Jon

 

[jondallimore]

Almost forgot, I would like it to be scaled to fit on one sheet of paper too...