The workbook will have to be saved in a macro-enabled. Give the highlighting a try, if it becomes a problem, just remove the VBA code or comment out the Application.Calculate line. Modern Excel is pretty smart about figuring which cells to re-calc when a manual Calculate is done. That’s true but probably not noticeable except for really large or complex worksheets. Downside of forcing calculationįorcing Excel to recalculate the worksheet for every cell movement will slow down the entire workbook. This little chunk of code has other uses, as you’ll see in the Headings of a selected cell option below. We don’t want that to happen when we’re cut/copy/pasting so the IF statement stops that. The code invokes the SelectionChange event then forces Excel to recalculate the worksheet. Private Sub Worksheet_SelectionChange(ByVal Target As Range) This code goes into each worksheet that you want it to work in.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. Archives
June 2023
Categories |