Use Macros on Password Protected Worksheets in Excel
HTML-код
- Опубликовано: 30 май 2024
- Excel File: www.teachexcel.com/excel-tuto...
Excel Forum: www.teachexcel.com/talk/micro...
How to make macros that will work on password protected worksheets in Excel - this includes a step-by-step guide to modifying your macros to work on these protected worksheets as well as a few additional steps that will help you build more robust macros for this scenario.
In addition to working on protected worksheets, you will learn how to use VBA / Macros to check if a worksheet is protected and also to enable a macro to work on a worksheet while keeping it password protected for the user.
After viewing this tutorial, you should have no trouble working on protected worksheets.
Enjoy!
TeachExcel.com
Best tutorial on RUclips!
Thanks a lot. Finally a protection code that actually works.
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. This is just the information I've been looking for. Solved my issue.
instaBlaster
Thanks, What I exactly needed, Spot on
It worked for our project! Thank you.
Thanks so much! What I needed:).
Thank you!
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 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.
Nice! Thanks. (Subbed)
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 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
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.
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
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.
Thank you!