Run VBA without show

[Ajay]

I want excel to run the VBA code without showing me what it is doing.
Which code should i use for that?

 

[Socko]

Sub RunWithoutShow()
Application.ScreenUpdating = False

'Paste the vba code here

'end of code
'Change screenupdating property to true
Application.ScreenUpdating = True
End Sub

I hope this helps...


Selva V Pasupathy
For more on Excel, VBA, & other Resources
Please visit: http://socko.wordpress.com

 

[enigma]

You may also

(inserting into quote from code example bellow from Socko)

Use Application.Visible property to hide the application entirely

Sub RunWithoutShow()
Application.Visible = False
Application.ScreenUpdating = False 'If you hide the app leave screen
updating set to false in it will improve performance


' 'Paste the vba code here

'Change screenupdating property to true
Application.ScreenUpdating = True
Application.Visible = True
End Sub