Hi there.
I am using Application.GetOpenFilename with Multi-Select to open
multiple files sequentially for processing. After hitting the Open
button it works perfectly but the dialogue box is replaced by a grey
background until processing is complete - not very aesthetic for the
user! Any ideas on how to supress this box?
TIA, Dave

Dave,

Try DoEvents immediately after showing the box.
--
Jim Cone
San Francisco, USA
http://www.realezsites.com/bus/primitivesoftware


"AussieDave"

wrote in message
Hi there.
I am using Application.GetOpenFilename with Multi-Select to open
multiple files sequentially for processing. After hitting the Open
button it works perfectly but the dialogue box is replaced by a grey
background until processing is complete - not very aesthetic for the
user! Any ideas on how to supress this box?
TIA, Dave

Thanks Jim. Unfortunately it didn't seem to have any effect. Thanks
for your time anyway. Dave

Do you have ScreenUpdating set to true when you show the Dialog?
--
Jim Cone
San Francisco, USA
http://www.officeletter.com/blink/specialsort.html


"AussieDave"

wrote in message
Thanks Jim. Unfortunately it didn't seem to have any effect. Thanks
for your time anyway. Dave

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

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