First, there’s the Single Document Interface (SDI). If you have two linked documents open and you calculate, both documents go into the calculation tree.
That’s where every document is in it’s own application container. So it’s not exactly separate application containers.
Its main purpose is to allow you to put one spreadsheet on one monitor and a different spreadsheet on another monitor. My problem with SDI is that I was still using Excel 2003 menus for five addins. It forced me to rewrite them using the Ribbon UI – not a bad thing, but my client probably wasn’t including that cost in the cost of upgrade.
But we have fancy new ribbon icons, so all is well, right?
This Workbook should be active at the end of the procedure, but it is not.
Comment out the first line of code and This Workbook is active at the end of the procedure The actual code I was running when I first encountered the problem would cause a runtime error if This Workbook.
My code opens templates, unprotects them, writes stuff, combines them into a final report, and reprotects them.
The first thing I did was get stingy about my protection.
Certain vba macros / codes take a long time to run or execute the actions required. Sometimes, there could be one or more macros which cover multiple processes and this status bar will be useful to know at which process, the macro has reached.Screen Updating = True End Sub Crossposted: microsoft.com/Forums/wpapps/en-US/…The biggest problem I'm running into is that when I run the code (despite having Screen Updating set to False), it visibly opens the library file while it runs the macro.To make sure this is efficient going forward, I want to prevent that from happening. Range("g" & Lower & ":g" & Upper) my Objectname = "ckbox Print Labels" & ckbox add Chk = True For Each ctrl In Active Sheet. Public Sub addcheckboxes(By Val Lower As String, By Val Upper As String) Dim ws As Worksheet, my Objectname As String, add Chk As Boolean Set ws = Workbooks("nursery.xls"). Screen Updating = False ckbox = Lower ' add a checkbox for printing For Each cell In ws.