To improve the speed of execution of code, screen updating can be disabled. This means that Maxsurf will not redraw the screen every time a change is made, reducing the amount of work being done as the code executes. Screen updating can be disabled at the beginning of the code and then enabled at the end of the code;
Sub ScreenUpdating()
msApp.ScreenUpdating = False
'--------------
'Code Goes here
'--------------
msApp.ScreenUpdating = True
End Sub
This code will make the Maxsurf user interface dormant while the code executes, then display the altered settings once completed