Hello!
I have a sheet protected and filters enabled. I use this code to enable sort and filters:nevetherless, when I try to sort, I receive this message in excel: "The cell or chart you re trying to change is on a protected sheet.
ActiveSheet.Protect userinterfaceonly:=True, Password:="1", AllowSorting:=True, AllowFiltering:=True, AllowFormattingColumns:=True
ro make changes, click Unprotect Sheet in the Review tab (you might need a password)."
How I should to modify the code?
Thanks
suggest you upload a sample workbook with some typical data and instructions on how to reproduce the problem.
Regards, TMS
Trevor Shuttleworth - Retired Excel/VBA Consultant
I dream of a better world where chickens can cross the road without having their motives questioned
'Being unapologetic means never having to say you're sorry' John Cooper Clarke
Thanks for your answer.
So, I have attached a file. The password is "1" and it enter automatically by code (you can see the code in the console).
Now, when I try to sorting A to Z (or viceversa is no matter), for example the name, the error message appears.
Instead, I have not problem with filters.
Thanks again.
The only way that I can get it to sort when the sheet is protected is if ALL the cells are unlocked.
This is possibly related to the fact that it is a Table and Tables seem to be sensitive to locked cells/rows/columns.
A workaround may be to provide a button to unlock and sort the sheet. Not ideal but needs must.
Regards, TMS
Ok thank you.
Hello milt2010,
Would the attached sample Workbook work for you?
Regards
Please consider:
Be polite. Thank those who have helped you. Then Click on the star icon in the lower left part of the contributor's post and add Reputation. Cleaning up when you're done. If you are satisfied with the help you have received, then Please do Mark your thread [SOLVED] .
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks