Create Print "Button" in a cell

F

Fabledmyth

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
 
D

Don Guillett

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

Gord Dibben

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
 
Top