+ Reply to Thread
Results 1 to 4 of 4

Can you protect a cell AND copy/paste it?

  1. #1
    Registered User
    Join Date
    09-27-2017
    Location
    Texas
    MS-Off Ver
    Office 2013
    Posts
    7

    Question Can you protect a cell AND copy/paste it?

    I am building a document where there will be a lot of formulas that I don’t want getting altered. But I would like the user to be able to delete or copy the cells and insert/paste them lower on the page. These would be pasted directly under the cells copied and would move the existing rows down.

    Is there a way to make the cells un-editable but still be able to copy/past/delete them?

  2. #2
    Forum Expert dflak's Avatar
    Join Date
    11-24-2015
    Location
    North Carolina
    MS-Off Ver
    365
    Posts
    7,910

    Re: Can you protect a cell AND copy/paste it?

    Protect the sheet with the option to select both locked and unlocked cells. You can copy/paste a locked cell.

    To delete it you have to unprotect the sheet. This bit of code will do it. Assign a control key to it. It will also delete values

    Please Login or Register  to view this content.
    One spreadsheet to rule them all. One spreadsheet to find them. One spreadsheet to bring them all and at corporate, bind them.

    A picture is worth a thousand words, but a sample spreadsheet is more likely to be worked on.

  3. #3
    Registered User
    Join Date
    09-27-2017
    Location
    Texas
    MS-Off Ver
    Office 2013
    Posts
    7

    Re: Can you protect a cell AND copy/paste it?

    When I try to paste or insert the copied rows I get an error.

    "The cell or chart you're trying to change is on a protected sheet."

    "To make changes, click Unprotect Sheet in the Review tab (you might need a password)."

  4. #4
    Forum Expert dflak's Avatar
    Join Date
    11-24-2015
    Location
    North Carolina
    MS-Off Ver
    365
    Posts
    7,910

    Re: Can you protect a cell AND copy/paste it?

    The cell you are pasting into must be unlocked.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Protect data validation list from copy paste
    By Eftychia in forum Excel Programming / VBA / Macros
    Replies: 17
    Last Post: 02-29-2016, 03:20 PM
  2. Protect duplicate formatting from copy / paste?
    By theorange in forum Excel General
    Replies: 0
    Last Post: 10-18-2013, 01:03 PM
  3. [SOLVED] If I protect a column, will I be able to sort, copy and paste?
    By LaurieLaurie in forum Excel General
    Replies: 2
    Last Post: 03-19-2013, 02:08 AM
  4. Can I protect my cells from copy/paste
    By farakhkhan@yaho in forum Excel General
    Replies: 1
    Last Post: 07-11-2008, 02:21 PM
  5. how to protect validated cells from copy-paste
    By qbraz in forum Excel General
    Replies: 2
    Last Post: 12-26-2006, 02:13 AM
  6. Protect Cells from Copy and Paste
    By kbraaten in forum Excel General
    Replies: 3
    Last Post: 11-29-2006, 04:43 PM
  7. Protect from copy/paste
    By jamex in forum Excel General
    Replies: 0
    Last Post: 03-18-2006, 04:21 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1