Word screen updating

  reddwarfcrew 23:08 23 Mar 2006
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.

Elsewhere on IDG sites

Galaxy Note 8 vs iPhone X

Awful clip art from 1994 is being tweeted every hour by a bot

iPhone X vs Samsung Galaxy Note 8

Les meilleurs navigateurs internet 2017