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

[exl]

My workbook consists of almost 25 sheets, I want to protect 11 sheets. My criteria for protecting are as follows:

1. User cannot delete any cell
2. User should be able to use SORT, AUTOFILTER, drop down selection from COMBO BOXES
3. Most of the sheets contain charts, they should be updated as per the user selection
4. User should not be able to see the formulas in the formula bar
5. User should be able to copy the data

I have tried all the general options in Excel, which does all the above work, but they leave the cells unlocked, which means user can delete the contents

Thus I hope this can be achieved only by a macro, please help.

 

[exl]

Any solutions please...

 

[sdsurzh]

Dear Exl,

Apart from 1 & 3 rest can be done by protected option before doing you have to select all the cells and format cells (CRTL+1) ==> protection tab uncheck Locked & check Hidden.

Filter cannot be applied after protection so before that apply filter.

Now press ALT+T+P+P Allow all users of this worksheet to:
check
1.select locked cells
2.select unlocked cells
3.sort
4.use autofilter


Thank You,
SK

 

[exl]

Dear Exl,

Apart from 1 & 3 rest can be done by protected option before doing you have to select all the cells and format cells (CRTL+1) ==> protection tab uncheck Locked & check Hidden.

Filter cannot be applied after protection so before that apply filter.

Now press ALT+T+P+P Allow all users of this worksheet to:
check
1.select locked cells
2.select unlocked cells
3.sort
4.use autofilter


Thank You,
SK

Dear SK,

I have already done what you have suggested. The problem is, yo achieve the desired results, we have to make certain cells unlocked which leaves them vulnerable. Can you suggest a solution in addition to what you already said, where user cannot modify any cells

 

[exl]

Would appreciate some help / guidance here