Print

  • Thread starter Thread starter Lord Of The Morning
  • Start date Start date
L

Lord Of The Morning

Question I have made this excel script, is there a way that I can have an
image or cell that when clicked will print a sheet? Using some type of
formula.

Can you tell im new to all this?

Nick
 
the selectionchange event fires when a cell is selected. You could possibly
use that event to trigger the print.

Right click on the sheet tab and select view code.

Private Sub Worksheet_SelectionChange(ByVal Target As Excel.Range)
if Target.count > 1 then exit sub
if target.address = "$A$1" then
if target.value = 1 then
activesheet.printout
end if
End if
End Sub


Although I would see such functionality as a hazard with a lot of accidental
printouts.
 
Back
Top