Protect sheet against sorting only

[collis47]

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

 

[RichardSchollar]

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

 

[Nasir]

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.

 

[collis47]

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






- 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?