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

Комментарии • 26

  • @621prakash
    @621prakash 19 дней назад

    Best tutorial on RUclips!

  • @M4rt1nX
    @M4rt1nX 3 года назад

    Thanks a lot. Finally a protection code that actually works.

  • @MsLarianne
    @MsLarianne 2 года назад

    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
    @abdelrahmangharieb486 3 года назад +2

    Thanks. This is just the information I've been looking for. Solved my issue

    • @TeachExcel
      @TeachExcel  3 года назад

      I am very glad to hear this!!! You are most welcome :)

  • @Lodgeitude
    @Lodgeitude 4 года назад +2

    Thanks. This is just the information I've been looking for. Solved my issue.

  • @abdullahalshaikh39
    @abdullahalshaikh39 3 года назад

    Thanks, What I exactly needed, Spot on

  • @xyrusangelosalvosa8985
    @xyrusangelosalvosa8985 Год назад

    It worked for our project! Thank you.

  • @jadeelliott7124
    @jadeelliott7124 2 года назад

    Thanks so much! What I needed:).

  • @JC-jf8bi
    @JC-jf8bi Год назад

    Thank you!

  • @melkamzenatube8000
    @melkamzenatube8000 4 года назад +2

    I love so much bro, you did a lot to me

  • @wizzarin424
    @wizzarin424 9 месяцев назад

    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
    @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.

  • @TBsThaiBoxing
    @TBsThaiBoxing 4 года назад

    Nice! Thanks. (Subbed)

  • @jstan3076
    @jstan3076 2 года назад

    That's great tutorial. Can you do one with VBA Button to run with Protected sheet Please

  • @anil11996
    @anil11996 3 года назад

    Sir, how to protect workbook without opening into d:drive with all files in many folders and sub folders

  • @roaamer76
    @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?

  • @cmlosaria
    @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

  • @wayneedmondson1065
    @wayneedmondson1065 4 года назад +1

    Thanks.. good tips on PW protecting and worksheet security. Thanks for the insights.. learned something new.. particularly the UserInterfaceOnly:=True argument. Thumbs up!!

    • @TeachExcel
      @TeachExcel  4 года назад +1

      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.

  • @kishsand5385
    @kishsand5385 3 года назад

    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
      @TeachExcel  3 года назад

      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

  • @rajkumarkarapa
    @rajkumarkarapa 3 года назад

    i dont like to write password in macros. is there any solution to run macros in protected sheet

    • @TeachExcel
      @TeachExcel  3 года назад

      Password protect the project and no one can see inside of it.

  • @jordanrouse2029
    @jordanrouse2029 4 года назад

    Thank you!