Thread: Dialogue Boxes
View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.programming
Jim Cone Jim Cone is offline
external usenet poster
 
Posts: 3,290
Default Dialogue Boxes

Dave,
Turn on ScreenUpdating before showing the dialog.
Jim Cone
San Francisco, USA
http://www.realezsites.com/bus/primitivesoftware



"AussieDave"
wrote in message

First four lines of macro:
Application.Calculation = xlManual
Application.ScreenUpdating = False
Application.DisplayAlerts = False
Application.DisplayStatusBar = False

Do you reckon there are any problems with that?
Thanks, Dave