I write large macros that are used by dozens of different users. The
single thing that makes the most difference in how quickly the macros
execute is the default printer that each user has assigned. The more
wonderful bells-and-whistles the printer, the slower the macro will go.
I have my own default printer assigned to a plain vanilla HP Deskjet
that we don't even have (just loaded the driver). When I want to
actually print something (rarely), then I change the default printer.

Try changing your printer assignment by choosing File / Print, and then
choose a simple printer. You can then click CLOSE to get out of the
printer assignment window so you don't actually have to print anything
(like your macro workbook). Then execute the macro as you usually
would.

Hope that helps,

Nancy