Doble click a cell and running a macro

[Cristian]

Hi

Is there any posibility by clicking or double-clicking a cell in a
range to run a macro?

What I am trying to do is, if a user clicks (or double clicks) on a
cell in a range the coresponding worksheet is unhide.

I am passing the ActiveCell.Value as a parameter to a function which
unhides the coresponding sheet. (the value of the cell is the name of
the sheet to unhide).

I don't know how to make the connection between clicking on the cell
(actually a range of cells) and the macro.

Thank you
Cristian

 

[JE McGimpsey]

One way:

Put this in the worksheet code module:

Private Sub Worksheet_BeforeDoubleClick( _
ByVal Target As Excel.Range, Cancel As Boolean)
If Target.Address(False, False) = "J10" Then
Cancel = True
MyMacro1 Target.Value
End If
End Sub

in a regular code module:

Public Sub MyMacro1(ByVal sIn As String)
Worksheets(sIn).Visible = True
End Sub