Disable sorting but allow filtering

Anyone help on this?

There must be some guru who knows if this is possible or not?? Please help!

Don't enter it in a module or a normal subroutine (sub).

Go into your VBA editor (Ctrl+F11), Then click 'this workbook, (if you want it applied to whole workbook). In the drop down boxes above the code area, find 'WORKBOOK' and 'OPEN'. Drop the two lines of code in there. If the code is correct (assuming it is!) this will trigger every time the workbook is opened. You will need to save and re-open for it to kick in.

If this doesn't work, I will look at the body of the code for you.

Hi TKCZBW

Thanks so much for the reply. Ctrl+F11 adds a new worksheet named Macro1 - thats not right is it? Before I was rightclicking on the sheet1 tab at the bottom, then clicking view code, then double clicking on sheet1 and entering the code in there, as that's the only sheet I want it applied to. I just tried entering the two lines of code only and it still won't work...

No, you don't want a macro worksheetsheet (they aren't really supported any more and so really only good for backwards compatability).

Go into your worksheet code, as before, then select 'WORKSHEET' and 'ACTIVATE'. drop the code in there.

When you say it doesn't work, do you mean it errors out, or it just doesn't do what you want?

Okay I see, apologies I was being stupid - the macro is now running, but it doesn't do what I want it to. I want 100% functionality with everything apart from sorting. I want to be able to filter but just no sorting. This macro seems to just protect the worksheet which isn't what I want at all. I know I can protect a worksheet and disable sorting only but that also disables any kind of data entry which is something I don't want.

Thanks

OK. I would actually protect the sheet, but then on the protect sheet dialogue allow users to actually do everything but sort the cells. I've just tryed it out and it seems to do what you want.

You need to enable filtering before you protect the sheet (i.e. 'CTRL+L') otherwise you won't even be able to filter.

I want to be able to edit cells though and protecting sheets stops this

Nope, not if you go to the protectsheet dialogue box (which version of excel are you in?) you can set it to allow editing of cells and just lock sorting. You will also need to select the entire sheet, go to format cells and turn off 'locked'. This should do it.

It works!! Thanks!

Good!

Best,

TKCZBW