Sort and filter on a protected sheet

[Oryon]

Hello,

I am working on an Excel spreadsheet where I would like it to be possible to sort while the sheet is protected, as it contains formulas and will be used by multiple users. So far, I have only managed to add a macro that allows filtering and clearing filters, but I would also like sorting to be possible.

Could you help me, please?

TEST Sort and Filter.xlsm
	A	B	C	D
1
2
3
4
5
6
7	NAME	NUMBER	EXIT DATE	MAX. EXIT DATE
8		32224	05/02/2024	19/02/2024
9			04/01/2024	18/01/2024
10			15/02/2024	29/02/2024
11	PEDRO	568956	09/02/2024	23/02/2024
12	MARIA	235414	26/01/2024	09/02/2024
13	ANA	785412	26/01/2024	09/02/2024
14	JUAN	545856	09/02/2024	23/02/2024
Hoja1

Cell Formulas
Range	Formula
D8:D14	D8	=IF(C8="","",WORKDAY.INTL(C8,10,1,))

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
D8:D14	Cell	contains a blank value	text	NO
D8:D14	Expression	=Y($D8<=HOY()+5;$D8>HOY())	text	NO
D8:D14	Expression	=$D8>HOY()+5	text	NO
D8:D14	Expression	=$D8<=HOY()	text	NO

 

[Michael M]

At the start of the code put

activesheet.unprotect

at the end of the code

activesheet.protect

you should then be able to put a sort line within the code.

 

[Peter_SSs]

Cross-posting (posting the same question in more than one forum) is not against our rules, but the method of doing so is covered by #13 of the Forum Rules.

Be sure to follow & read the link at the end of the rule too!

Cross posted at: Sort and filter on a protected sheet
+ Other places. Please provide links to all the places that you have asked this question.

If you do cross-post in the future and also provide links, then there shouldn’t be a problem.

 

[Oryon]

Welcome to the MrExcel Message Board!

Cross-posting (posting the same question in more than one forum) is not against our rules, but the method of doing so is covered by #13 of the Forum Rules.

Be sure to follow & read the link at the end of the rule too!

Cross posted at: Sort and filter on a protected sheet
+ Other places. Please provide links to all the places that you have asked this question.

If you do cross-post in the future and also provide links, then there shouldn’t be a problem.

I apologize a thousand times for what happened. I've been dealing with this for several days and can't find the solution. My knowledge in VBA is very limited, which is why yesterday I decided to post it in multiple forums at once. I'm truly sorry. My most sincere apologies. I`m really sorry.

This are the other post where I ask, but whitout solution:

Excelforum
forums.excelguru.
msofficeforums

 

[Peter_SSs]

This are the other post where I ask, but whitout solution:

Excelforum
forums.excelguru.
msofficeforums

Thanks for this, but could you please post links to your threads there? (No real need for Excel Forum though since I posted the link above)
It would be reasonable for anybody considering helping here to be able to visit those other forums if they want to see if any suggestions have already been made, or question resolved.

 

[Oryon]

This are the other post where I ask, but whitout solution:

Excelforum
Sort and filter on a protected sheet
msofficeforums Sort and filter on a protected sheet

 

[Peter_SSs]

Thanks for the links.

 

[Oryon]

Finally I did more or less what I was searching for. Maybe is not the best way to do it, but i hope it could help me. Thank you for your patient.
As I can upload here the Excel, I put another web where is it, in case you need o you could improve.

Sort and filter on a protected sheet

Hello, I am working on an Excel spreadsheet where I would like it to be possible to sort while the sheet is protected, as it contains formulas and will be used by multiple users. So far, I have only managed to add a macro that allows filtering and clearing filters, but I would also like...

www.excelforum.com