Protect sheet against sorting only

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

collis47@hotmail.com - 30 Jan 2007 00:58 GMT

OK, I want to protect a sheet against sorting only,

eg i want the user to be able to do everything else, just not sort the
data.

is there an easy way to do this, alternativly is there code that will
do the same thing?

Thanks

Reply to this Message

RichardSchollar - 30 Jan 2007 08:17 GMT

Hi

A potential solution might be to select all the sheet cells and go
Format>Cells>Protection tab and make sure the Locked checkbox is
unchecked, then apply Protection but leave Sort unchecked
(obviously). Then users should be able to do pretty much everything
except Sort.

Hope this helps!

Richard

On 30 Jan, 00:58, colli...@hotmail.com wrote:

> OK, I want to protect a sheet against sorting only,
>
[quoted text clipped - 5 lines]
>
> Thanks

Reply to this Message

Nasir - 30 Jan 2007 13:31 GMT

If you want to try that with VBA code, then perhaps you should try
using recording macro. Hit the record button, and use the instructions
posted by Richard. Once you are done you can stop the macro and view
the code. In excel, you can do a lot of things through recording
macros and then proceeding from there(customizing or else). That is a
good starting point to learn writing procedures and functions for
later.

Nasir.

On Jan 30, 4:17 am, "RichardSchollar" <richardschol...@hotmail.com>
wrote:

> Hi
>
[quoted text clipped - 19 lines]
>
> > Thanks- Hide quoted text -- Show quoted text -

Reply to this Message

collis47@hotmail.com - 31 Jan 2007 01:24 GMT

On Jan 30, 5:17 pm, "RichardSchollar" <richardschol...@hotmail.com>
wrote:

> Hi
>
[quoted text clipped - 21 lines]
>
> - Show quoted text -

OK, that was what i first did, the issue is with everything allowed,
except sort, you can't edit a cel, eg change an entry. this is where
my problem lies. any thoughts?

Reply to this Message

Rate this thread: