NEED HELP - When I password protected by sheet I added "format cell", "Format columns" and "format rows" from the selection in the password "Allow all users of this worksheet to:" pick list. I did add that ActiveSheet.Protect "123" to my macro, The PROBLEM when I ran the macro, the protection diverted back to the basic "Select Locked Cells" and "Select Unlocked Cells" only and removed what I added. So after running the macro I no longer was able to format. How can I keep what I select in the Protect Sheet drop-down list? (using Excel 2019)
@@Dr333Ow thank you, I'll give it a try, I'm assuming in the macro I'm adding the line " ActiveSheet.Protect AllowUsingPivotTables:=True" If I understand your correctly.
I protected my diagrams from being selected or edited with password but after applying some macro on the sheet the diagrams on the sheet became selectable and editable even protected with password. It like the protection does not work anymore when I apply micro. Please help.
I am trying to input the code into my macro in Excel 2016 but it gives me an error: Run-time error 1004 Application-defined or object-defined error Could you please assist?
I cannot use slicers and Macros simultaneously. When I ran the macro using this method, the slicer becomes disabled again. So I need to unprotect everytime
Close other workbooks except the one with the code and try again. If that doesn't work, upload the code that you are using with a sample file in our forum and ask there and it will be easier to troubleshoot: www.teachexcel.com/talk/microsoft-office?src=yt_comment
Thanks.. good tips on PW protecting and worksheet security. Thanks for the insights.. learned something new.. particularly the UserInterfaceOnly:=True argument. Thumbs up!!
Glad I could throw-in some new info! I do like that little feature, but, oddly enough, I have yet to see it widely used - maybe its just that not many people know about it; I'm hoping it's that instead of that there is some way it causes massive problems down the road that I didn't notice hah. I'll mark it for a Quickie tutorial down the road so more people will learn about this specific feature of macro sheet protection.
Best tutorial on UA-cam!
amazing! I've been trying to run a clear macro on a protected sheet with no success. This is so elegant and simple. Thank you
Thanks a lot. Finally a protection code that actually works.
It worked for our project! Thank you.
Thanks. This is just the information I've been looking for. Solved my issue.
instaBlaster
I love so much bro, you did a lot to me
NEED HELP - When I password protected by sheet I added "format cell", "Format columns" and "format rows" from the selection in the password "Allow all users of this worksheet to:" pick list. I did add that ActiveSheet.Protect "123" to my macro, The PROBLEM when I ran the macro, the protection diverted back to the basic "Select Locked Cells" and "Select Unlocked Cells" only and removed what I added. So after running the macro I no longer was able to format. How can I keep what I select in the Protect Sheet drop-down list? (using Excel 2019)
I have the same issue, I allowed pivot table use while protected, after running the Macro it protects the sheet again but without the pivot table use.
Figured it out, ActiveSheet.Protect AllowUsingPivotTables:=True
@@Dr333Ow thank you, I'll give it a try, I'm assuming in the macro I'm adding the line " ActiveSheet.Protect AllowUsingPivotTables:=True" If I understand your correctly.
Thanks so much! What I needed:).
Thanks, What I exactly needed, Spot on
That's great tutorial. Can you do one with VBA Button to run with Protected sheet Please
Sir, how to protect workbook without opening into d:drive with all files in many folders and sub folders
I protected my diagrams from being selected or edited with password but after applying some macro on the sheet the diagrams on the sheet became selectable and editable even protected with password. It like the protection does not work anymore when I apply micro. Please help.
I am trying to input the code into my macro in Excel 2016 but it gives me an error:
Run-time error 1004
Application-defined or object-defined error
Could you please assist?
Thank you!
I cannot use slicers and Macros simultaneously. When I ran the macro using this method, the slicer becomes disabled again. So I need to unprotect everytime
i dont like to write password in macros. is there any solution to run macros in protected sheet
Password protect the project and no one can see inside of it.
Nice! Thanks. (Subbed)
When i used the code it says the document is not open on the line " if activesheet.protectcontents" ..
Can you please help me in this
Close other workbooks except the one with the code and try again. If that doesn't work, upload the code that you are using with a sample file in our forum and ask there and it will be easier to troubleshoot: www.teachexcel.com/talk/microsoft-office?src=yt_comment
Thanks.. good tips on PW protecting and worksheet security. Thanks for the insights.. learned something new.. particularly the UserInterfaceOnly:=True argument. Thumbs up!!
Glad I could throw-in some new info! I do like that little feature, but, oddly enough, I have yet to see it widely used - maybe its just that not many people know about it; I'm hoping it's that instead of that there is some way it causes massive problems down the road that I didn't notice hah. I'll mark it for a Quickie tutorial down the road so more people will learn about this specific feature of macro sheet protection.
Thanks. This is just the information I've been looking for. Solved my issue
I am very glad to hear this!!! You are most welcome :)
Thank you!