Originally Posted by David Godinger[_2_]

I’m using UserInterfaceOnly, so that I can run macros and still keep my sheet protected. I tried to use ActiveCell to calculate only certain ranges, without stopping protection for the rest of the worksheet. I need to recalculate only those ranges, but leave the rest of the sheet, unchanged, and on manual calculation. I tested ActiveCell and made sure that it works for, as example, putting up a message box, but I can’t get it do what I want. Here’s the VBA: Private Sub Worksheet_Change(ByVal Target As Range) Dim KeyCells As Range ' The variable KeyCells contains the cells that will ' cause an alert when they are changed. Set KeyCells = Range("AJ6:DT105") If Not Application.Intersect(KeyCells, Range(Target.Address)) _ Is Nothing Then Range("last4SessionsCalculations").Calcu late Range("rolesSuggested").Calculate End If End Sub