That worked on what I setup to test with otherwise I wouldn't have suggested it.
It's unlikely I setup every thing the way you have it.
If you attach a sample workbook where this doesn't work and I'll check out what's happening.
If you remove
Code:
On Error Resume Next
does Excel indicate any errors ?