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 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 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 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?
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.
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
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. This is just the information I've been looking for. Solved my issue
I am very glad to hear this!!! You are most welcome :)
Thanks a lot. Finally a protection code that actually works.
Best tutorial on UA-cam!
It worked for our project! Thank you.
I love so much bro, you did a lot to me
Thanks, What I exactly needed, Spot on
That's great tutorial. Can you do one with VBA Button to run with Protected sheet Please
Thanks so much! What I needed:).
Thank you!
Sir, how to protect workbook without opening into d:drive with all files in many folders and sub folders
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 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 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 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?
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.
Nice! Thanks. (Subbed)
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.
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. This is just the information I've been looking for. Solved my issue.
instaBlaster
Thank you!