Posted to microsoft.public.excel.programming

John[_140_] John[_140_] is offline

external usenet poster

Posts: 57

Prevent user from sorting a Table

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?

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Prevent Tab from User Delete	Ardy	Excel Worksheet Functions	2	September 9th 09 02:38 PM
Prevent user from using Name	Matlock	Excel Discussion (Misc queries)	5	March 13th 08 04:58 AM
Merged Cells Prevent sorting	jayceejay	New Users to Excel	2	February 14th 07 05:39 PM
Prevent User from saving	crapit	Excel Programming	2	July 26th 04 03:48 PM
How do I: prevent user from scolling down and right?	jasonsweeney[_39_]	Excel Programming	3	February 5th 04 07:06 PM

All times are GMT +1. The time now is 03:51 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us