User form not working when Password with Edit Range Allowed Initiated

  • Hello everyone,

    I have a user form that is being keyed in by multiple users. I have enabled password protected with certain range to be allowed.

    However, upon doing so it triggers an error saying that the cell or chart is in a protected sheet.

    How can I enable the form to be used for all worksheet with the password encrypted in it?

    Is possible to encrypt the password without VBA and allowing the form to work?

    Thanks!

  • None of the sheets are protected.


    You can unprotect the sheet at the start of the code, run the code then re-protect it.


    Alternatively, you can use ProtectWithUserInterFaceOnly


    Excel is not really meant for multi users and you will probably encounter problems. You can use Collaborate if you have OneDrive and share the file that way.


    Share and collaborate with Excel for the web