Word screen updating

  reddwarfcrew 23:08 23 Mar 06
Locked

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
PleaseWaitFrm.Show

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

Application.Visible = True
Application.ScreenUpdating = True
Application.ScreenRefresh
PleaseWaitFrm.Hide
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?

Thanks

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