|In the future, should you need to post code in this forum, please read the How To referenced in my signature line. Click on How To.|
Private Sub Workbook_SheetActivate(ByVal Sh As Object)
' This will calculate every time Event Summary sheet is selected
If Sh.Name = "EVENT SUMMARY" Then
You need to use Sh.Name since Sh is declared as the Object.
Posting Tip: Before posting Data or VBA Code, read this How-To.