unprotect worksheet

  1. A

    Having trouble doing a simple Replace

    Hi, I had hoped to attach the small troublesome excel file (size: A1:F374) but just discovered I do not have permission. Not sure how to demo what the problem is without attaching the file - can I be given permission please? The file has numerous zeros (0). I want to use Replace to replace all...
  2. 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...
  3. V

    Unprotect strange behaviour

    Hi to MrExcel staff and users, As my username states, I am not a profesional programmer but rather a VBA amateure so - be gentle :) I have been struggling with a protection issue in an Excel VBA project I am doing and just can't seem to figure out what the heck is going on in my file. The...
  4. C

    Get Excel to trigger a macro when user protects or unprotects worksheet

    I don't know if this is possible, but is there a way to get Excel to trigger a macro whenever a user either protects or unprotects a certain worksheet within a workbook via Protect/Unprotect Sheet. Ideally, I would like to be able to trigger one macro if the worksheet is protected and a...

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