Hi Angel

Use a Class Module...see this Link...if you have issues implementing let me know.

http://www.bettersolutions.com/excel...A619860332.htm