Hey all,
Simple question. How do I get excel to run the macro in the background?
In my code:
I tried Application.ScreenUpdating = False, but without any results :/
Please Login or Register to view this content.
The macro shows my -sarcasm- wonderful -/sarcasm- way of programming.. But although i'm not a programmer, I love doing this.
You want to use events. Search the web for "excel events vba" and you will see there are lots of events available (on open, on close, before print, on update, etc.). Too much to cover in this forum, but plenty of web pages to get you started.
Pauley
--------
If I helped with your issue, I'd appreciate a rep bump (hit the '*' icon to the bottom left of this post).
I'm not sure that we are on the same page here.
The macro does run (when a button is clicked).
But it's running in two different files, it flashes those files right in my face. And I want to prevent that from happening (so screenupdating would come in mind, but that doesn't seem to work on more than one workbook.)
Sorry I misunderstood your question (and then I took a break from this forum). So where is screenupdating 'failing'? Is it during the saves? It seems like it should work, but you are seeing otherwise, so maybe there is certain code where excel will still switch between files. I tried to write some test code which copied data from one workbook to another, and the screenupdating worked as expected.
No problem, the functions and macro's just made my file really slow. So I decided to change some things.
Now it already works better, so the problem doesn't bother that much anymore.
I will mark it as solved for now. When I can really test the file I might reopen it and try to explain things as clear as possible.
Tnx
There is no reason why ScreenUpdating would not carry over, it is the application that it applies to not the workbook...
Make sure you put Application.ScreenUpdating = False in the beginning before you open the file, before on error and then at the very end put Application.ScreenUpdating = True before you end your sub and you should find that it runs and you don't see anything...
-If you think you are done, Start over - ELeGault
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks