refresh of screen -- commando

  • Thread starter Thread starter matthias
  • Start date Start date
M

matthias

Hi all,

can anyone give me the commando for

stop & start REFRESHING OF THE SCREEN, so the macro can
run invisible.

txs a lot,

mat
 
Mat,

Use something like

Application.ScreenUpdating = False
' your code here
Application.ScreenUpdating = True
 
Application.ScreenUpdating = False 'at start of code
Application.ScreenUpdating = True 'at end of code

Amit
 
Back
Top