I have a workbook I get from my website. When I save it and enable it gives an error in the macro.
Option Explicit
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
Dim sht As Object
For Each sht In Sheets
Fails at this line
Anyone any ideas?
Option Explicit
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
Dim sht As Object
For Each sht In Sheets
Fails at this line
Anyone any ideas?