Excel Locking Freeze

[sassriverrat]

I have an old excel sheet- never really ever had problems with it.

Anyway- recently put a print macro into it (see below) to add to the macro that was previously there (which gives you an idea how old this workbook is....) and now the two data-validation drop downs don't work (they show a circle with a slash when the mouse hovers over them) and the password-protection doesn't even allow me to input the password to unlock individual sheets. However, if I wait a few minutes sometimes it allows me to finally click unprotect and input the password....ideas?

Sub Alphabetize()'
' Alphabetize Macro
' Macro recorded 5/29/2003 by *****
'


'
    ActiveSheet.Unprotect
    Range("M4:AB32").Select
    Selection.Sort Key1:=Range("M4"), Order1:=xlAscending, Header:=xlGuess, _
        OrderCustom:=1, MatchCase:=False, Orientation:=xlTopToBottom
    Range("K9").Select
    ActiveSheet.Protect DrawingObjects:=True, Contents:=True, Scenarios:=True
    
End Sub


Sub PrintAREA()
'this is the piece I just wrote
ThisWorkbook.Worksheets(Array("Pilot Card", "Max Squat - UKC")).PrintOut
End Sub