Hiding Excel when running a function

[rossmcl]

How do you stop it being visible on the screen when an Excel function is running?

At the moment, I have a function doing a lot of cell offsets and worksheet creates etc.

I want to stop all this being visible on the screen. (ie I dont want the cursor to move etc).

Is this possible?

thanks
rossmcl

 

[SkipVought]

Hi,

Best to post coding questions in the VBA Visual Basic for Applications (Microsoft)Forum

Sub YourSub()
  Application.ScreenUpdating = False

... you code here

  Application.ScreenUpdating = True
End Sub

Skip,
[sub]
[red]Be advised:[/red]
Alcohol and Calculus do not mix!
If you drink, don't derive! [/sub]