• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

restriction for delete or chage in cell

kalpeshpatel

New Member
in worksheet 1 contain very important data i like make a macro for user do not delte & change the data in any cell in sheet1 without permission
 
Hi, kalpeshpatel!

How will be that permission granted every time they want to update that range?

In Excel 2010 (and if I remember well in 2007 too), you can assign a password for editing a group of cells, but when you give the users that password... how do you reinstall the protection?

Regards!
 
If they're not supposed to make any changes AT ALL to the range, I would just protect the worksheet. (Data - Protection - Protect Sheet)
 
Back
Top