sheet protect

  1. M

    Full protection of sheets

    Good day. I have some excel project and is circulated in a group of people. Some sheets contain complicated formula so I protected the sheet and allow them to just view for their reference. My concern is that some have removed the protection ..... Please advise on how to fully protect sheets...
  2. E

    Macro to protect a sheet but allow sort, autofilter, charts, copy

    My workbook consists of almost 25 sheets, I want to protect 11 sheets. My criteria for protecting are as follows: User cannot delete any cell User should be able to use SORT, AUTOFILTER, drop down selection from COMBO BOXES Most of the sheets contain charts, they should be updated as per the...
  3. E

    Sheet protection - passwords

    Hi I have the following macro... Sub ProtectSheets() Sheets("Outlook").Protect EnableSelection = xlNoSelection Sheets("FY Utilisation Report").Protect EnableSelection = xlNoSelection Sheets("Resource Check").Protect EnableSelection = xlNoRestrictions Sheets("Project").Protect...
  4. F

    Grey Out Issue

    I just took over a new job and they have a database in Excel 2007 Compatibility Mode that they want a sheet protected. However, the sheet protect and a myriad of other functions are greyed out. I have tried everything to get back these functions, but they seem to be locked out. The old system...

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