The first thing I did was get stingy about my protection.Excel & Word have the Screen Updating method thru which a developer can lock the main window from unnecessarily redrawing itself whilst the macro is being executed. If left alone, redrawing is not only ugly on the eyes it also takes more time for the macro to reach completion.
With the new encryption scheme, protecting and unprotecting a worksheet in code takes a touch longer. I don’t know what exactly to do about the protection problem.My code opens templates, unprotects them, writes stuff, combines them into a final report, and reprotects them.If possible, i appreciate someone can tell me how to accomplish it using Xla. Best wishes, Loy SAMPLE CODE Public Sub Onshore Trfr(By Val my Value As Integer, my Type As Integer) Application. Screen Updating = False Select Case my Type Case 1 If my Value = 1 Then Sheets("LIB"). You'll be able to ask any tech support questions, or chat with the community and help others.
I've got a listbox which populates a second listbox from cells on a hidden worksheet which is done through macros.
i suspect it is because I use select/activate, copy and paste from different other worksheet which is seen as a LIBRARY. I wonder if it is possible to save the library in XLA and then call the objects from XLA file using EXCEL VBA.
Is it a better way of dealing the flickering screen.
Creating an xla file is not necessary and really depends on what you are looking to do with this code. For example, the code below will create two separate worksheet objects, and change the name of each of the worksheets (without having to select the sheet before applying the name change).
Before I start, I will admit I posted this in a forum that helps me a lot with another Office product, but as of this post they were not able to shed any light on this issue.
Sub Insert Text() Dim Doc As Document, str Text To Insert As String, str Text To Find As String Dim i As Long, doc To Open As File Dialog, s Hght As Single Dim rng To Search As Word.