SameerMirza
asked on
excel vba code - explaination
Hi,
Mostly when we see the programs we the following two lines at the start of e.g a sub,
application.displayalerts = false
application.screenupdating = false
Now I understand that 'displayalerts' = false would cut any display messages
and 'screenupdating' = false means no processing is shown on the screen
does means the cmd window would not be shown? which appears when vba is processing
I an new to VBA and just trying to clear out my logics
It would great if any one could provide me with explanation on it
Thanks
Mostly when we see the programs we the following two lines at the start of e.g a sub,
application.displayalerts = false
application.screenupdating
Now I understand that 'displayalerts' = false would cut any display messages
and 'screenupdating' = false means no processing is shown on the screen
does means the cmd window would not be shown? which appears when vba is processing
I an new to VBA and just trying to clear out my logics
It would great if any one could provide me with explanation on it
Thanks
I don't know what you mean by cmd window - I assume you are not talking about a Command window since that has nothing to do with VBA.
ASKER
ok :)
thats why I am here trying to confirm what it actually doesn/ prevents from appearing on the screen
thats why I am here trying to confirm what it actually doesn/ prevents from appearing on the screen
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
ok :) thanks alot
I just wanted to be sure - guess a stupid one but it helps
I just wanted to be sure - guess a stupid one but it helps
ASKER
thanks