Not showing a macro executing in Excel

[WeAreNotAlone]

Hi all

I have just started writing macros in Excel. When it executes the screen and woorkbooks flash for several seconds. I have been told that it is possible to stop excel doing this.

Is this correct and if so what is the code and where is the best place to put it in the coding?

Thanks

Mally

 

[Zathras]

Congratulations. You are learning a very valuable skill.

There is a VBA forum which is a better place for questions like this. See forum707 and faq707-4105

 

[AnotherHiggins]

Welcome to TekTips, WeAreNotAlone.

That certainly is possible. Just add the following code to the beginning and end of your code:

sub example
application.screenupdating = false
'...
'your code
'...
application.screenupdating = true
end sub

[tt]_____
-John
[/tt]Help us help you. Please read FAQ181-2886 before posting.

 

[WeAreNotAlone]

Thanks for your help anotherhiggins.

Will give it a go.

Mally

 

[AnotherHiggins]

For future reference, Zathras is right - VBA-specific questions should be posted to the VBA Visual Basic for Applications (Microsoft) Forum.

But still, I'm glad to help.


[tt]_____
-John
[/tt]Help us help you. Please read FAQ181-2886 before posting.