I have the code below in as a worksheet procedure to automatically change
the column width to accomodate entries. It works fine Excel 2002 but when a
friend tried it in Excel 97 it would not work. Is this an Excel 97 feature
or does this code need to be written a different way to cover versions 97 to
2002. I would really value any help.

Private Sub Worksheet_Change(ByVal Target As Range)
ActiveSheet.Unprotect
With ActiveSheet.Range("B12:Q30")
..Columns.AutoFit
End With
ActiveSheet.Protect
End Sub

Kind Regards
Graham Haughs
Turriff, Scotland