Make a 'Print button'

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

BrianT - 30 Jun 2006 19:23 GMT

How would I make a cell into a 'print button' (radio button?)

I need to be able to mouseover and either click or press enter on
cell, and doing so would cause a range of other cells to be printed. S
cell A1 would be my button, click on it or hit enter once it wa
highlighted and it would print cells D10-x41 say

Reply to this Message

Ron de Bruin - 30 Jun 2006 20:56 GMT

Try this event

Copy it in the sheet module
If you select A1 it print the range

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
If Not Application.Intersect(Range("A1"), Target) Is Nothing Then
Range("D10:X41").PrintOut
End If
End Sub

Signature

Regards Ron de Bruin
http://www.rondebruin.nl

> How would I make a cell into a 'print button' (radio button?)
>
> I need to be able to mouseover and either click or press enter on a
> cell, and doing so would cause a range of other cells to be printed. So
> cell A1 would be my button, click on it or hit enter once it was
> highlighted and it would print cells D10-x41 say.

Reply to this Message

BrianT - 30 Jun 2006 21:57 GMT

Thank you my friend, I shall give it a try tomorrow

Signature

BrianT

Reply to this Message