call from ThisWorkbook

[Philosophaie]

I have a subroutine in sheet1 called root.

Private Sub root()
...
End Sub

I need to know how to access it from "ThisWorkbook"

Private Sub Workbook_Open()
...
Sheets("Sheet1").root 'This does not work
End Sub

 

[Datsmart]

Move your Root macro to a regular Module and call it "Sub Root()" instead of "Private Sub Root".
Then call it like this:

Private Sub Workbook_Open()
     Call Root
End Sub