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
|