Prevent user from sorting a Table

J

John

In Excel 2007 I have a Table that I would like the user to be able to
filter, but I want to prevent him from sorting . Is there a way to do this,
perhaps with some type of worksheet event? I noticed enabling the Sort
option of Protect Sheets prevents the user from both sorting and filtering,
so that doesn't work. Any other ways?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Cannot sort a table containing text 5
Undesirable sorting behavior 1
sort table listobject without table name 5
Create a chart from a table in word thats dynamic 0
Prevent user from Inserting new worksheet 4
prevent user from deleting a tab prevent running macro from menu 5
Format column widths from one table to a separate table on same page 1
To prevent a user from deleting and renaming a sheet in a workbook 3

Top