I made it a subroutine because it can be called from several different places.
Private Sub Deselect Cell(n Target Row As Integer) ' turning cell to unselected state With Selection .
Screen Updating = True in the code where I wanted the screen to refresh properly.
Actually, I hadn't turned screen updating off, I just needed to sprinkle Application. Screen Updating = False successfully in Office 2010.
It happens when there is transition among excel files.
The same macro worked properly in win 7 with office 2010.
The Visual Basic for Applications (VBA) programming language allows you to automate routine tasks in Excel—and it's not as hard to learn as most people think.
Hello dcanham, It is difficult to provide a solution in the absence of code controlling the check boxes. Set the Show Modal property in the Properties window to False. It sheet that the user sees does not update until after the code is done running altogether. Hi All, Does anyone know how to force the selected excel sheet to update the user's screen view? I discovered this when buttons were being made visible or not, it wasn't updating the screen. The user is selecting what they want to do off of a item checklist then pressing go. Actually, I hadn't turned screen updating off, I just needed to sprinkle Application. In this course, Excel expert Curt Frye offers a crash course on VBA, sharing techniques that can help users of Excel 2007 or later get more out of this powerful program.Curt covers creating subroutines and functions to hold code, and provides a solid grounding in the Excel object model.
Anyone know how to ensure no updating happens even if macro triggers additional macros to run? They do BUT the running of the second macro seems to start with updating = true. Lets assume for a moment that it is the setting back to true at the end of the secondary macro that is causing the issue, should I apply an updating check at point(s) when the macro returns to the originally called code? NEW QUESTION - If I do not set updating back to True how can that negatively affect the spreadsheet?