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 sort of unprotected cells on manually chosen sheets. Is this possible?
TIA
Please Login or Register to view this content.
Alan B
Last edited by Zagra147; 05-13-2014 at 01:29 PM.
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)
Never use Merged Cells in Excel
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.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks