View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
David Sauder[_2_] David Sauder[_2_] is offline
external usenet poster
 
Posts: 8
Default Msgbox freezing in beforeprint module

I couldn't duplicate this behaviour (in Excel XP), so I can't be sure
what is going on. However, it sounds like it MIGHT be a problem with
screenupdating being turned off by some other event procedure - that
"End" statement might prevent screenupdating being turned on again.
A couple of things to try:

1. replace END with EXIT SUB
2. if that doesn't do it, just before the exit sub put in msgbox
application.screenupdating just to see if the screenupdating is off
or not
3. add a break point and then step through this procedure to see if
any other code is being invoked (e.g. by some other application event)

David Sauder