Vba screen updating code

I have been following Screen Updating Property through Debug. Enable Events = True End Sub Sub DP_disbursement() Dim number_disbursements As Integer Application.

And then put a debug.print before/after each line (including before after the select line). and then put a debug print after the called sub ends and the code returns to the original sub. Well that narrows it down to the selecting I guess, and I guess further that it's specifically the selection of a sheet that wasn't the active sheet when you launched the macro.

I'm running a macro that has to open and run code from a module, then open a table after it's done.

The problem is that the user can see the code module a few seconds before the table is opened.

Still, any ideas why the Screen Updating = False doesn't work when I select a different sheet? Is it because the selection was performed in a different sub?

So, the debug.prints are correct, reflecting the fact that screen updating is off.

Search for vba screen updating code:

vba screen updating code-1vba screen updating code-68

Leave a Reply

Your email address will not be published. Required fields are marked *

One thought on “vba screen updating code”

  1. The judge hopes it will eradicate the girl's crush for the older man, but the judge's daughter and the playboy fall for each other. Cast: Alan Baxter, Lyle Talbot, Lila Leeds, Doug Blackley. A "good" girl works day and night as a dancer in Los Angeles to finance her brother's college education. Cast: Frankie Avalon, Annette Funicello, Deborah Walley, Harvey Lembeck, John Ashley, Jody Mc Crea, Donna Loren, Marta Kristen, Linda Evans, Don Rickles, Paul Lynde. They all have their own problems, which are strained to the breaking point by prejudice, inexperience and misunderstandings. Special features: feature commentary with director and cast members; deleted scenes; live footage from the feature commentary session; featurette; theatrical trailer; MCA soundtrack presentation: The Goops "Build me up Buttercup;" production photographs. Mary is a free-spirited young woman with a run-down New York apartment and a high fashion wardrobe.