Silent running

S

Stewart

Hello all,
Sorry to bother you with such a simple one but this is
driving me crazy - What's the vba equivalent of SWITCH
ECHO OFF to run a macro without the display?
regards,
 
R

Rob Bovey

Stewart said:
Hello all,
Sorry to bother you with such a simple one but this is
driving me crazy - What's the vba equivalent of SWITCH
ECHO OFF to run a macro without the display?
regards,

Hi Stewart,

Application.ScreenUpdating = False

--
Rob Bovey, MCSE, MCSD, Excel MVP
Application Professionals
http://www.appspro.com/

* Please post all replies to this newsgroup *
* I delete all unsolicited e-mail responses *
 
Top