Dialogue Boxes

  • Thread starter Thread starter AussieDave
  • Start date Start date
A

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
 
Dave,

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


"AussieDave"
<[email protected]>
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
 
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

File Open Dialogue Box to a Specified Location 1
list box dialogue msgbox 4
Microsoft Word will not close. No dialogue box evident. Help! 3
Open dialogue box and importing text files 2
How to create a modal Dialogue Box? 6
set var to folder path using Open Dialogue box 3
Input on a user form 2
Shutdown dialogue box 4

Back
Top