Dialogue Boxes

[AussieDave]

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

[Jim Cone]

Dave,

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


"AussieDave"
<davemenere@optushome.com.au>
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

[AussieDave]

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

[Jim Cone]

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"
<davemenere@optushome.com.au>
wrote in message
Thanks Jim. Unfortunately it didn't seem to have any effect. Thanks
for your time anyway. Dave

[AussieDave]

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

[Jim Cone]

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



"AussieDave" <davemenere@optushome.com.au>
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

[AussieDave]

Easy as that, eh?

Thanks a million Jim - worked a treat!!

Cheers, Dave