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
@abdelrahmangharieb486
3 жыл бұрын
Thanks. This is just the information I've been looking for. Solved my issue
@TeachExcel
3 жыл бұрын
I am very glad to hear this!!! You are most welcome :)
@M4rt1nX
4 жыл бұрын
Thanks a lot. Finally a protection code that actually works.
@621prakash
4 ай бұрын
Best tutorial on KZitem!
@xyrusangelosalvosa8985
2 жыл бұрын
It worked for our project! Thank you.
@melkamzenatube8000
4 жыл бұрын
I love so much bro, you did a lot to me
@abdullahalshaikh39
3 жыл бұрын
Thanks, What I exactly needed, Spot on
@jstan3076
3 жыл бұрын
That's great tutorial. Can you do one with VBA Button to run with Protected sheet Please
@jadeelliott7124
3 жыл бұрын
Thanks so much! What I needed:).
@JC-jf8bi
2 жыл бұрын
Thank you!
@anil11996
3 жыл бұрын
Sir, how to protect workbook without opening into d:drive with all files in many folders and sub folders
@wizzarin424
Жыл бұрын
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)
@abdulrahmanbalafaringani8859
Жыл бұрын
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.
@cmlosaria
3 жыл бұрын
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
@roaamer76
3 жыл бұрын
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?
@wayneedmondson1065
5 жыл бұрын
Thanks.. good tips on PW protecting and worksheet security. Thanks for the insights.. learned something new.. particularly the UserInterfaceOnly:=True argument. Thumbs up!!
@TeachExcel
5 жыл бұрын
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.
@TBsThaiBoxing
4 жыл бұрын
Nice! Thanks. (Subbed)
@rajkumarkarapa
4 жыл бұрын
i dont like to write password in macros. is there any solution to run macros in protected sheet
@TeachExcel
4 жыл бұрын
Password protect the project and no one can see inside of it.
@kishsand5385
4 жыл бұрын
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
@TeachExcel
4 жыл бұрын
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
@Lodgeitude
4 жыл бұрын
Thanks. This is just the information I've been looking for. Solved my issue.
Пікірлер: 26