Is it possible to call a "Private" Sub (located on one module sheet) from a sub located on a different module sheet? (see Ex below and conditions). The conditions are that the Sub must remain "Private" and the two subs remain on different module sheets (I know it will work if the sub is Public). Tks.
'(Example: Private Sub DoSomething is On sheet "Module1")
Private Sub DoSomething()
' code
End Sub
'(Then On sheet "Module2")
Sub AlsoDoSomething()
' Can't get the following line of code to work
Call DoSomething
End Sub
'(Example: Private Sub DoSomething is On sheet "Module1")
Private Sub DoSomething()
' code
End Sub
'(Then On sheet "Module2")
Sub AlsoDoSomething()
' Can't get the following line of code to work
Call DoSomething
End Sub