Link to home
Start Free TrialLog in
Avatar of Rayne
RayneFlag for United States of America

asked on

enable sorting on protected sheet vba

Hello

mySheet.Protect Password:=myPassword, DrawingObjects:=True, Contents:=True, Scenarios:=True, AllowFormattingColumns:=True, AllowFiltering:=True, UserInterfaceOnly:=True, AllowSorting:=True
I added the allow sorting but still….
still on protection, the sorting is giving error – see attached
willNotSort.jpg
Avatar of Rayne
Rayne
Flag of United States of America image

ASKER

what vba code i need to make the sorting work after protection?
ASKER CERTIFIED SOLUTION
Avatar of Martin Liss
Martin Liss
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
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.
Avatar of Rayne

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.