unprotect sheet vba

  1. V

    Unprotect doesn't work with VBA code

    Hello everyone, I have the following code which that does not allow the user to paste values in a Data Validation List Column. My problem is that I have columns (without data validation) that have to stay protected, columns With Data Validation List have no locked option from format cell, but...
  2. S

    Unprotecting Selected Sheets Only on Multiple Fil

    Hi, I have 20 files to edit, all of which have a differing number of tabs protected (with the same password), What I want to do is select the protected tabs on each file manually, then run some code to unprotect, I then do what I need to do and protect again using similar code. Also to note...
    • stroffso
    • Thread
    • unprotect macro button unprotect sheet unprotect sheet vba unprotect workbook
    • Replies: 3
    • Forum: Excel Questions
  3. D

    VBA Code to unprotect multiple sheets by entering p/w once for sheets that were auto protected

    I created a code to automatically protect multiple sheets in a workbook with a password of my choice but without having to manually enter it. Let's pretend the password = ORANGE. See code below:Sub ProtectTabs() Dim ws As Worksheet Set WSArray = Sheets(Array("Sheet1", "Sheet3"...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top