As the macro swaps from one to the other on my Mac it shows where the focus is so I see the 2 worksheets swapping but if I run the exact same macro on a PC it doesn't.
Screen updating is set to false at the start and to true at the end only with no sub routines called but I do call functions there is no reason to move selection or activate each workbook, just read and write fully qualified ranges activating workbooks or sheets, or selecting ranges in macros is bad practice and leads to errors in results and other issues AFAIK the is never any need to set application.screenupdating to true, as this will happen automatically when the code finishes i do my best to test code works before i post it, but sometimes am unable to do so for some reason, and usually say so if this is the case.
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.
IS there a way of stopping it from doing this on a Mac to save me that pain?I was watching the state of an object within the Workbook (the locked property of a specific style).