Private Macro

  • Thread starter Thread starter Fan924
  • Start date Start date
F

Fan924

When I change "Sub WBMoved" to
"Private Sub WBMoved"
Can it be accessed from other worbooks?
 
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

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