Janne
You would have a macro named say, MyMacro. This macro would be in a
standard module and it would contain all the instructions to print whatever
you want printed. Then you would place the following macro in the sheet
module for the sheet that has the cell you want to click on, say A1. When
you click on cell A1, the following macro will call MyMacro. Please post
back if this is not clear or you need more. HTH Otto
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
If Target.Count > 1 Then Exit Sub
If Not Intersect(Target, Range("A1")) Is Nothing Then _
Call MyMacro
End Sub