Hide everything other than the userform while macro is running

[cowelka1]

So I have created a macro to import data from another file when a document is opened. In an attempt to occupy the user I have created a user form to display while this runs and hidden the Excel file itself whilst this is the case.

The only problem I now have, is that when the source file is being opened to copy the data across, I get a windows prompt box telling me the status of that file being opened. Is there a way to hide this and show only the user form?

I'm sure this is going to be a simple line of additional code, but I can't find anything on any of the previous threads

What I have so far is as follows:

Application.Visible = False
UserForm1.Show vbModeless
Application.ScreenUpdating = False

Macro to open, import and close source file

Unload UserForm1
Application.Visible = True
Application.ScreenUpdating = True

 

[igold]

Hi,

Does this work:

Sub test()


    Application.Visible = False
    UserForm1.Show vbModeless
    Application.ScreenUpdating = False


[COLOR=#ff0000]    Application.DisplayAlerts = False[/COLOR]


    Macro to open, import and close source file


[COLOR=#ff0000]    Application.DisplayAlerts = True[/COLOR]


    Unload UserForm1
    Application.Visible = True
    Application.ScreenUpdating = True
    
    
End Sub

igold