I have a VBA program in Word that takes some time to do its thing. To assuage the user that the program is working, I display a form with messages and a progress bar to show what is happening. All is well until I create a new document that will display the results of the VBA program. The progress bar form is visible only when the original document is displayed. I would like the form to be visible while VBA is writing and formatting the new document.
I’ve tried hiding the form before creating the new document then I unhide the form, but it is visible only from the original document. I’ve tried turning Application.ScreenUpdating on and off to no avail.
Is there any hope of a solution?
--JRA in Priddis