Private Macro
 

When I change "Sub WBMoved" to
"Private Sub WBMoved"
Can it be accessed from other worbooks?

Private Macro
 

yes if you use "run"

Sub test_run()
Run "Book1.xls!SubInOtherWB"
End Sub

no if you use reference.

Sub test_callByName()
SubInOtherWB
End Sub

"Fan924" wrote in message
...
| When I change "Sub WBMoved" to
| "Private Sub WBMoved"
| Can it be accessed from other worbooks?

Private Macro
 

Thanks