asked on enable sorting on protected sheet vba
Hello
mySheet.Protect Password:=myPassword, DrawingObjects:=True, Contents:=True, Scenarios:=True, AllowFormattingColumns:=Tr
I added the allow sorting but still….
still on protection, the sorting is giving error – see attached
willNotSort.jpg
mySheet.Protect Password:=myPassword, DrawingObjects:=True, Contents:=True, Scenarios:=True, AllowFormattingColumns:=Tr
I added the allow sorting but still….
still on protection, the sorting is giving error – see attached
willNotSort.jpg
Microsoft ExcelMicrosoft OfficeVBA
Last Comment
Martin Liss
ASKER
what vba code i need to make the sorting work after protection?
ASKER CERTIFIED SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
Rayne, why the "B" grade? Please see this EE article on grading which says
A "B" grade means the solution given lacked some information or required you to do a good amount of extra work to resolve the problem. When closing the question, the asker should explain why a B grade was awarded.Please consider Requesting Attention so that a moderator can help you change the grade.
ASKER
Sure I will do that
This question has been classified as abandoned and is closed as part of the Cleanup Program. See the recommendation for more details.