Protect unprotect sheets with password and sort

Your post does not comply with Rule 3 of our Forum RULES. Use code tags around code.

Posting code between [CODE]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/CODE] tags makes your code much easier to read and copy for testing, it also maintains VBA formatting.

Highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found here



(This thread should receive no further responses until this moderation request is fulfilled, as per Forum Rule 7)

Done. Code tags added.

Perhaps if I do it again...
I have the following code (provided here some years ago) which works fine. But I now need to modify it to include an optional password and to allow manual sort of unprotected cells on manually chosen sheets. Is this possible?

Please Login or Register  to view this content.

Add password after protecting:

Please Login or Register  to view this content.

Sorry. That doesn't work. It doesn't ask for a password and the 'sort' icon on the ribbon is 'greyed-out'. I tried deleting 'Zagra147' and just left the quotes. Still didn't work. All I want to do is to duplicate the manual protect/unprotect with the "Select Locked Cells", "Select Unlocked Cells", "Sort" boxes ticked for all sheets.