How to call a public module macro in private module macro

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
 
Joined
Sep 3, 2008
Messages
164
Reaction score
5
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

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top