How to call a public module macro in private module macro

E

emmanuel

Joined
May 12, 2011
Messages
20
Reaction score
0
Hi,

I have a private module macro

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
If Target.Address = "$E$1" Then
Run "presence()"
End If
End Sub

But the macro presence is in "this worksheet" modulw

how should i call the macro presence??
Please help me
 
emmanuel said:
Hi,

I have a private module macro

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
If Target.Address = "$E$1" Then
Run "presence()"
End If
End Sub

But the macro presence is in "this worksheet" modulw

how should i call the macro presence??
Please help me
Click to expand...

Did you mean the presence macro is in ThisWorkbook" module? That would make it an application event and you should be able to call it from the sheet change event.


Stoneboysteve
 
Back
Top