You're calling this macro from the BeforePrint event? If so I have the
exact same problem. Calling it normally there is no problem.

I'm running Excel 2000 SP3 with the November 2003 Security Patch (K830349)
installed. The only way you can tell if you have it installed is to run
Application.Build. This will return "8216" if this patch is present. SP3
by itself returns "6627".

I tried this code in the BeforePrint event on a coworker's machine which had
SP3 but no security patch. It was fine. So it may be that this patch
introduced a bug.

I'll pass this on the MS but I don't have a solution other than the one you
found.

--
Jim Rech
Excel MVP