Sub, Public Sub, Function, Public Function ?

[theta]

Hi

What are the main differences (and best uses) of the above

I am dealing with multiple open workbooks, each with modules etc so want to ensure I am creating the correct modules and procedures

Some of the subs will open a workbook (OpenFile) and then perform analysis on the worksheets in the open workbook (do my subs need to be public then?)

Any help appreciated

Thanks

 

[Joe4]

See if these help:
http://www.your-save-time-and-improve-quality-technologies-online-resource.com/vba-private-sub.html

http://www.excelfunctions.net/VBA-Functions-And-Subroutines.html