Create Print "Button" in a cell
 

I need to find out how you make a cell into a print "button." So that, if
you click on that cell, it automatically prints out another worksheet in the
workbook

Create Print "Button" in a cell
 

You can put in a right_click event or a double_click event or a transparent
shape from the drawing toolbar.

--
Don Guillett
SalesAid Software

"Fabledmyth" wrote in message
...
I need to find out how you make a cell into a print "button." So that, if
you click on that cell, it automatically prints out another worksheet in
the
workbook

Create Print "Button" in a cell
 

Why don't you just draw a rectangle onto the cell and assign your print macro to
that rectangle?

Use ALT to snap the rectangle to the cell.

You can add a bit of color or not.

Or just place a button from the Forms toolbar onto the sheet and assign a macro
to that.

Running a macro from a cell would require further code of the beforedoubleclick
event type.


Gord Dibben MS Excel MVP

On Sat, 16 Dec 2006 03:32:00 -0800, Fabledmyth
wrote:

I need to find out how you make a cell into a print "button." So that, if
you click on that cell, it automatically prints out another worksheet in the
workbook