protect /macros

  1. D

    Protect multiple worksheets VBA

    Hi everyone, I need to protect all worksheets within multiple workbooks. No password needed to open to workbook, but I would like a password to make any changes on the actual worksheets. There are over 2,000 workbooks with multiple worksheets that need to be protected. The workbooks are a mix...
  2. D

    VBA not functioning completely - protect sheets and workbooks

    Being new to the VBA band wagon, i'm having some issues troubleshooting the code below. It is supposed to be able to choose multiple excel files in a folder and protect all of the worksheets within them as well as each workbook. The protect of the workbook does not have a password, it is simply...
  3. S

    Macro to Protect All except a few Ranges

    Hey all, I think this should be pretty straight forward, but I'm struggling a little. (I'm still learning VBA.) I'm trying to protect a workbook, but leave a few ranges available for co-workers to edit. I have the ranges set up so I can go to: Review Ribbon: Changes Group: Allow Users to...
  4. K

    CONDITIONAL LOCKING - Please Help!

    I need help with a macro so that simply typing in an X in a cell will password protect the entire spreadsheet. My boss wants me to have our purchase orders lockup once he puts in the PO information and puts his digital signature, he wants to type in an X in a cell and have the entire thing...
  5. G

    Protected Worksheet: All cells except 1 need to be locked

    I have a worksheet in which a user selects from a drop down list and from there everything else is filled out. In order to protect this and prevent users from messing up the form (thus preventing numerous headaches for me), I want to lock all cells except for this one cell containing the drop...
  6. E

    Debug Macro on Protect Option ---

    A) I have this mini dashboard where I have to merge a few cells and wrap them. So I used one of the macro from this site to autohightadjust the merged and wrapped cells. B) Then I had to record another macro to run the above macro on a group of cells Then I created another macro to run B)...

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