How to sort listobject in protected worksheet

**efernandes67** · 06-08-2012, 08:27 PM

Hi,

I have a listobject with several columns and I am using the following code to protect the sheet:

Please Login or Register  to view this content.

The sorting is not working. A message appears "the cell or chart that you are trying to change is protected and therefore read-only"

what seems to be the problem?

Regards,
Elio Fernandes

**JoeMo** · 06-08-2012, 10:31 PM

After AllowFiltering:=True add: ", UserInterfaceOnly:=True" (w/o the " marks)

**efernandes67** · 06-09-2012, 05:31 AM

Hi Joe,

I did what you told me but the sorting does not work. The filtering works. I attached a file so that you can see and tell me what is wrong. I put the code above in the worksheet.

**JoeMo** · 06-09-2012, 12:01 PM

Sorry, I didn't understand what you were trying to do until I looked at your workbook. The command I gave you would allow a macro to do the sorting, but not a user. To allow a user to sort, you must unlock all the cells in the list object before you protect the sheet.