protecting sheet prevents me from selecting filter

[dbwiz]

I unlocked the top row, which is filtered, then protected the worksheet, as there are a couple of columns with formulas that I do not want touched. However we should be able to filter the sheet. I cannot figure out how to protect the sheet and still be able to filter the data. How can I do this?

 

[Datsmart]

Depends on what version of Excel you're using:
With Excel 2002 or later, when you protect the sheet, you have the option to allow users to use autofilter (one of the checkboxes).

Try Andrew's suggestion here:
http://216.92.17.166/board2/viewtopic.php?t=53916
ActiveSheet.EnableAutoFilter = True
ActiveSheet.Protect contents:=True, userInterfaceOnly:=True
The UserInterfaceOnly property is not saved with the workbook, so it must be reset when it is opened.

In either case, you must setup the AutoFilter prior to protecting the sheet, plus, no sorting is allowed at all, just autofiltering.

 

[dbwiz]

Thanks!