Killian,

First of all, I realized that the excel sheets in question had a password protection. I didn't think that would matter because upto now, I have been manually deleting specific sheets in question without having to "unprotect" them. But just as a safe measure I unprotected them all - and the code still won't work.

Then I thought there must be something about hte security settings on the company's network that prevents vba from running so i copied the excel file off the network onto my local hard drive and it still won't work.

The code works perfectly with the documents provided in your zip file but does not work on the files I have (even w/ the above changes). So there must be something about my excel file which is preventing the code from running - I can't figure it out. I'll add the watch in the window and see what happens next..... i'll report back.