Hello,
I found these two codes for unprotecting/protecting sheets. How can I combine these codes to build only one macro that would do - If sheets unprotected Then password and Protect OR If sheet protected Then password and Unprotect ?
Code:
Please Login or Register to view this content.
You may try:
Please Login or Register to view this content.
- Please remember to mark threads Solved with Thread Tools link at top of page.
- Please use code tags when posting code: [code]Place your code here[/code]
- Please read Forum Rules
Here is a very very simple example:
Please Login or Register to view this content.Please Login or Register to view this content.
Hi Izandol,
Your code works, but I am now trying to achieve same with toggle button, I think It would look better.
I want toggle button to be True If sheets are protected. If you click again on toggle button and don't type password or type incorrect password then I would like toggle button to be again True, and stay like that - until I type correct password.
this is code, but It not working properly :
I know I'm annoying, but If someone can do this, I would appreciate very much.Please Login or Register to view this content.
Sniper thanks,
but I prefer to unprotect/protect with passwords on one toggle button.
You may try:
Please Login or Register to view this content.
Ok, just and you would like to put in the password? Did Izandol cover your question?
If your Dreams don't scare you......They are not big enough
If you like my answer don't forget to click on the *
Izandol thanks,
that's exactly what I wanted
Izandol answered my question, thanks for help although !Originally Posted by Sniper
Izandol, sorry to bother again,
but I copy that toggle button from my first sheet on every new sheet. And when I protect cells in one sheet, toggle button stays True only on that sheet, on other sheets It stays as when copied. How can I fix that, don't want to delete toggle button on new sheets ?
Also noticed that If I don't enter password to protect, It also protects cells and toggle button goes True. And then If you click again, It unprotects everything....
Last edited by Lukael; 03-17-2014 at 07:05 PM.
If you wish to change protection for all sheets it will be simpler to use menu instead of button on every sheet.
I have one Userform but this button wouldn't be quite good in terms of Userform's purpose, that's why I wanted button to be on sheets.
Did you mean like adding cmdbutton to open menu and then perform code ? I also noticed that code works only in sheet, If I put it in module or Workbook buttons doesn't respond...
I mean button on menu bar (Excel 2003 and before)/Ribbon (Excel 2007 and after).
Ok then, looks like this is really best option. But I'll keep digging in code, maybe I find a solution in VBA...
Thanks for all help, you really helped me !
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks