Run VBA without show

  • Thread starter Thread starter Ajay
  • Start date Start date
A

Ajay

I want excel to run the VBA code without showing me what it is doing.
Which code should i use for that?
 
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
 
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
 
Back
Top