application.visible=false

keepITcool

< email : keepitcool chello nl (with @ and .)
< homepage: http://members.chello.nl/keepitcool


"Henry" wrote:

We are running a macro from a workbook that has data in
cells. When we run the macro, one part of the code is:

FileOpenName = Application.GetOpenFilename("Text Files
(*.txt),*.txt", 1, "Open FMS Text File")

which opens a dialog box.

We have set screeen updating to False.

When we run the macro, the original workbook is still
visible in the background.

Is there code we can use to "blank out" the background
while the macro is running? (We will still need to see the
Open File" dialog box.)

Thanks.