G[i On Errorj61.u On Error Go TovƁu Exit Subv62.u On Error Resume Nextv Err Iu WFNg63NJi Openj64NEۑi Close, Save, Save Asj SUMIF̊ԈႢɂpt H[}X̒ቺɂāb GNZZi617ĵ낢ȏFTrue False̔Ƃ́b Excel}NVBAZpi615jZ𐳂肷@2b Excel}NVBAZpi56jtp Xf BNg [email protected]ɕb Excel}NVBAZpi415je LXg NVBATv Wi44jŌ̋iw蕶jȍ~̕ob GNZZi326j擪̐l AŌ̐lob GNZZi326j [email protected]ɃV[g`Fb Nb Excel}NVBATv Wi323j̎QƂĂZ擾b Excel}NVBATv Wi318j 1.ŏIs̎擾i End, Rows.
I want to have the ready-only / notify message box (see attached) disappear when the already opened file was retrieved by other user. Name = "LOG" Then Exit Sub Dim s Last Value As String Dim l Last Row As Long With Sheets("LOG") l Last Row = . Cells(l Last Row, 1) = Create Object("wscript.network"). Screen Updating = false" because I saw the yellow highlight go over the line in debug mode. Calculation = xl Calculation Automatic Application. Screen Updating from within the code instead of the immediate window, but I'm fairly sure what I'll find. This function gets called by an event handler that catches a Commands Bar button event (? Basically, we create a menu bar and one of the buttons in our custom "File" menu is labeled "Load Portfolio" which calls this function. I have encountered the same symptoms and can't think as to why it's happening. I think that maybe something has broken in my excel because even when I closed out of excel and opened a brand new 2003 workbook with no previous code I was getting the same problem. The interesting thing is that *some* of my modules allow Screen Updating to be set to False, there's only a few that don't. However, I *can* change the Screen Updating from the immediate window. Screen Updating = False b Global Change Event = True Application. About to go home for the day, but I plan on trying to print Application. So while Screen Updating always is True in debug mode, this is not the issue for me.