reason online dating - Pplication screenupdating false

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.

Then comment out the line which turns off screen updating and see what happens; you should find that you scroll down the sheet as the numbers get filled.

Screen Updating = True Try running it and you should see a short pause followed by column A getting filled with numbers.

When I moved the code I wanted to run before save to it's own module, then called the module from Workbook_Before Save, it worked like a charm...(events disabled in module, so additional sheet level events did not trigger) Hoping this will help someone else out - drove me crazy for a while!!! Caption = "Ready to clock out of last task." Command Button2. I was killing myself over why the heck screen updating was not set to false!!!! I solved my problem with a very simple solution: At the very very end of the code put: Application. I was watching the state of an object within the Workbook (the locked property of a specific style).

Comments