I don't know much myself johngunn but I bet if you check, you are missing a reference library object --look in tools in the VBA Editor when the error occurs. Whatever is missing will be described there. You can do a file search on your whole drive and see if its misplaced. Check Bob Hansen's reply on my other thread . . .