I used some old code created in Excel 2007 and repurposed it for another file in Excel 2003. See code below.
The user got a run-time error 448. I imagine there is some wording in the code that isn't suited to the prior version of Excel? Or is it that UserInterfaceOnly should equal False? Unfortunately, I can't recreate the problem on my PC. The code words great in Excel 2010's compatibility mode.
Any light you can shed, would be very much appreciated!
ActiveSheet.Protect Password:="password", UserInterfaceOnly:=True, AllowSorting:=True, AllowFormattingCells:=True, _
AllowInsertingRows:=True, AllowDeletingRows:=True, AllowFormattingColumns:=True, AllowFormattingRows:=True