I have tried 2 options to autofit column width but receive the following error:
Run-time error '1004':
Application-defined or object-defined error

Private Sub Workbook_Open()
    Application.ScreenUpdating = False
    Worksheets("Summary").Activate
    Columns("B:E").AutoFit
    Range("B:E").EntireColumn.AutoFit
Thanks in advance