vba - Accessing Public sub in ThisWorkbook module -

I have the VBA code in Sheet1 module and I want to call the sub process in that sheet 1 module when the workbook will open I:

  Private sub workbook_on () Call MyMacro End Sub  

Behind SHeet1 I

  Public Sub Mimocry () ....... end sub  

When the workbook opens, I get an error:

Sub or Function is not defined "GetReutersData" call

I am open from the event Mkro How can I call?

I need the MyMacro code in Sheet1 module because there should be a way to do this. I can not create a new module

  private sub workbook open () sheet 1. Macro End All