Hide Excel Workbook when running VBA 1

[jpgactmod]

I am using VBA to export Access data to an Excel Workbook. The VBA code includes the following:

Ans = MsgBox("Existing Data in " & xWkBkName & " will be replaced. Continue?", vbYesNo, "Data Replacement Warning")
If Ans = vbNo Then Exit Sub

When the program runs, the MsgBox is hidden by the Excel Workbook. How can I ensure that the MsgBox remains visible?

Another problem I have is that while the Excel workbook is being populated, the User can interrupt the operation while selecting an Excel cell. Can I lock Excel while the workbook is being populated to prevent User interruption?

Thank you for any help.

Jim

 

[PHV]

Why not playing with the Visible property of the Excel.Application object ?

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[jpgactmod]

PHV,

Yes, that solved both of my problems (visibility and preventing a User from interrupting the program).

Thank you.

Jim