Disable xls view update

[Nimrod]

Sorry to bother you guys on such a small matter but I just can't for the life of me remember how to stop screen refreshes while a macro is running. In other words I don't want the excel screen update until the macro is finished running. I've been looking but just can't put my finger on the command !!
Can anyone help ?

Thanks

 

[Legacy 98055]

Application.ScreenUpdating = False

set to True when finished.

Tom

 

[bolo]

Application.screenupdating = false maybe
HTH

 

[Nimrod]

Thanks TsTom it was driving me crazy trying to remember ... cheers mate.

 

[Jack in the UK]

Good to see you post Nomod, few guys have asked me where you are, ggod i trust.

Help - questions are that,and often help guys how have just read your post, so all good stuff

BTW look how many you have really helped

Take care Jack