Rick I want to thank you for your reply; however that thread you forwarded me is not working. I am using Microsoft Office 2010 - I initially thought that this error was related to the version of Excel; therefore I recreated the file in Microsoft Office 2007. Unfortunately that did not work. I spent a good two to three hours recreating the file but I am getting the same error. It seems to happen when I add a command button that triggers a macro that is designed to automatically create a PDF of the active worksheet and send that worksheet in an e-mail (i.e. I am using Ron de Bruin's code for this). I just don't understand what the problem. I will keep doing research on this. I am big fan of automation - I have to figure out a way to make this work.