Word screen updating

  reddwarfcrew 23:08 23 Mar 06

Hi, I have a vba macro that build a letter. As it takes a few seconds and the screen flashes a lot as the macro goes up and down the document, I wanted to have a 'please wait' box com up, but it's not quite qorking.

On pressing my okay button, the first bit of my code is:

Load PleaseWaitFrm
Application.Visible = False
Application.ScreenUpdating = False

then the code runs and does its stuff and then I have the following

Application.Visible = True
Application.ScreenUpdating = True
Unload PleaseWaitFrm

the problem I have is that the hiding of 'PleaseWaitFrm' is not happening
and I have to manually click the x to close it and then word re-appears all
nicely done. So why isn't the hiding of my user form working?

Can anyone help?


This thread is now locked and can not be replied to.

What is ransomware and how do I protect my PC from WannaCry?

Disney layout supervisor Rob Dressel on the challenges of visualising Moana

Siri vs Google Assistant