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.

Nintendo Switch review: Hands-on with the intuitive modular console and its disappointing games…

1995-2015: How technology has changed the world in 20 years

This abstract video touches on division in our technologic world

Best alternatives to iTunes for Mac | Best music players for macOS: Free your music from the…