clemsoncooz,
private/public defines the scope of the sub. It's not only about user being able to run it with ALT+F8, but also from where you can run the sub in VBA.
Look at the attached file. in Module 1 you have a private sub. in module 2 there are two subs that try to run the private sub from Module1. One is using call and the other application.run
Actually the project does not even compile because call method does not "see" the private sub in the other module. However the application.run does the job. try to run each of the two with F5/F8 to see the difference.
buran
Bookmarks