Call Private Sub

[MarkCBB]

HI there,

I am trying to call a piece of code, but I am getting the following error: "Cant execute break in code"

but there is no break in the code, however the code that i am calling is a Private sub with Option Explicit. (Not my code so not sure)

is there a way to do this. here is the code that I am using

Sub Send()
Sheets("sender").Visible = True
Sheets("sender").Select
Call Sender_Click
End Sub

 

[RoryA]

What is the Sender_Click code and where is it located?

 

[MarkCBB]

The code is located in a worksheet, not module, the code sends out emails. (Code from Ron de Bruin).

 

[RoryA]

Unless both bits of code are in the same worksheet, you cannot call the other sub that way - you need the other sub to be public and you need to refer to is as a amethod of the other sheet:

Call sheet1.sender_click

for example where sheet1 is the code name, rather than tab name, of the sheet with the code.