This macro will automatically unfreeze all of the worksheets on an Excel spreadsheet . . .
Dim Ws As Worksheet
Application.ScreenUpdating = False
For Each Ws In Application.ActiveWorkbook.Worksheets
.FreezePanes = False
Application.ScreenUpdating = True
. . . this can be an important tool when you're processing lots of Excel files.
The source is this site: