View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Gord Dibben Gord Dibben is offline
external usenet poster
 
Posts: 22,906
Default 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