I have the following code:
Private Sub Workbook_SheetChange(ByVal Sh As Object, ByVal Target As Range)
Range("A1").Calculate
End Sub
Tub does not work until I do a calculation on another sheet. Just switching the sheets does not trigger the sub. What could be possible issues?
The automatic calculation is turned off, if that is relevant.
New contributor
Ammar Tahirovic is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.