• 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.

Prevent Formula Deletion but allow for data input

B

Becky Mattas

New Member
I have created a spreadsheet that others will be entering in the data. I want to prevent the deletion of formulas in designated columns but allow for data to be entered in other columns. All the while, allowing them to copy an existing row & insert the copied row. I have tried several VBA codes I have found on the internet but none allow for the rows to be copied & inserted. I don't want the users to be able to hit delete or backspace in the cell. In fact, I don't even care if they are unable to click in the cell. They shouldn't need to. I have tried to "protect" it using the Excel protection but that doesn't seem to work the way I want it either.
 
Welcome to the Forum..

AFAIK, I doubt you can insert copied row while the sheet is protected..However, you can insert rows or columns while the sheet is protected...

Let us see...if experts have a different say..
 
Last edited:
You must log in or register to reply here.
Back
Top