Thanks WRowan for your response. I tried everything suggested at this web location:

http://www.globaliconnect.com/excel/...=79&Itemid=475

But those suggestions are assuming the worksheet is protected which is not the case. I only have a password enabled to open the file, other than that the worksheet has no protection enabled.

I could remove the password and allow macros to run, but I would have to manually add the password back before closing which is such a hassle. There must be a more efficient way to approach this but I don't have a clue.