protect unprotect

  1. T

    Protect and Upprotect - Word 2007 Doc

    Mornin', I've got a template in Word 2007 that I'm creating that several people will be using and, to avoid issues from people accidentally changing or deleting stuff in the document, I'm restricting editting to form fields only and password protecting it. What I want to happen is for the...
  2. C

    VBA to protect all sheets with password AND options of selecting locked/unlocked cells and editing objects

    Hi, I'm new to VBA and need help. I have a workbook with 40 sheets in it that I need to protect. I'd prefer to do this all at once. Users need access into some of the sheets so I want to protect the sheets and allow them to select locked and unlocked cells...along with allow them the ability...
  3. T

    ActiveWorkbook.Protect issue

    I have below code that works ok but if i run it twice it seems to toggle protect and unprotect.... leaving the workbook unprotected....! Is there a way i can stop this? Sub HideChart() ActiveWorkbook.Unprotect (1234) Sheets("Chart").Visible = False ActiveWorkbook.Protect (1234) End Sub
  4. B

    Unprotecting a Range

    Hello all, So I have a Userform, which contains a button then when clicked, directs the user to a worksheet where they have to enter information into certain cells. I am trying to protect this worksheet, except for this specific range of cells, which I would like to leave unprotected. I...
  5. J

    VBA code - protect - using vba code

    Hi, Is it possible to set a vba protect code with the lock for viewing with vba code. So unprotect/protect your vba code inside the vba code?

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