How to call a public module macro in private module macro

[rinijg]

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

 

[RoryA]

Do you mean it's in the ThisWorkbook module? If so, why is it not in a normal module if you need to call it from other routines?

 

[rinijg]

ok..let me make myself clear...
i have a macro called presence in "this worksheet" module.
the basic idea of this code is as follows. i have a dropdown menu in sheet1 cell E1, which contains names of some machine. when i select one machine name from that, i want the macro presence to run(this macro has all the calculations related to a machine).
for this i put the following code in the module of sheet1

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

i am not sure if what i did is correct... when i am running it shows the error "presence macro is not define"

i hope you got my confusion..
thanks a lot

 

[RoryA]

There is no "this worksheet" module. If you mean the same sheet module as your event code, then just use

presence

or:

Call presence

 

[rinijg]

oh!!!! i am really sorry.. thats "this workbook module"
the presence code is in "this workbook" module and the other code is in sheet 1 module..
really sorry for the mistake

 

[GTO]

In worksheet's module:

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
    Application.Run "ThisWorkbook.Presence"
End Sub

In ThisWorkbook:

Sub Presence()
    MsgBox "I was found :-)"
End Sub

@Rory:
This seems nutty to me. I made the Sub 'Presence' Private and it still ran. Why?

 

[GTO]

@rinijg:

Sorry, I forgot to mention that I certainly would have the called sub in a standard module.

 

[RoryA]

Application.Run has no sense of privacy.

 

[GTO]

Thanks Rory. Slow fingers here, I was trying to edit, as had just found a couple of threads. Sigh... I think I actually knew that at one point; too many brain cells leaking out somewheres...

I like the way you put it