unprotect sheet error

  1. S

    Unprotect Sheets - Multiple Passwords - VBA

    So I have a workbook with 100+ sheets. The sheets are protected and use either one of two different passwords. I need a way to unprotect all of the sheets cycling through the two different passwords if one or the other fail to unprotect the worksheet. I don't know which sheets are using which...
  2. R

    Excel asking to unprotect an unprotected worksheet

    I am working on a worksheet that has been protected off and on. I unprotected this AM, but XL will not allow changes and instructs to unprotect the WS, but it is already unprotected. The WB is not protected and never was. I am at a loss as to how to work around this problem. Any suggestions will...
  3. D

    Data Validation User Error Causes Workbook to Unprotect Itself

    This one has got me stumped. Any help would be severely appreciated. I have built an occupancy projection spreadsheet for our employees in the field. They are to project move ins and move outs once a week. After the appropriate week is passed, those projection cells are programmed to lock via a...

Watch MrExcel Video

This Week's Hot Topics

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
Top