+ Reply to Thread
Results 1 to 2 of 2

Pasting Protected cells

  1. #1
    Registered User
    Join Date
    12-04-2019
    Location
    Halifax, NS
    MS-Off Ver
    2013 (15.0.5189.1000) MSO (15.0.5172.1000) 32-Bit
    Posts
    3

    Pasting Protected cells

    Good day

    I manage a Work Order tracker that is used by many people in my organization. I have added some conditional formatting and formula's to make my life easier, but need to protect my document from unwanted changes. When a new entry is added, we "Copy" and "Insert Copied Cells" the last row to keep all the formatting. I can get my cells to paste over but what happens is the "Locked" cells are now no longer locked. With the people using the sheet, I need the properties to be copied over every time. Not sure if this is possible but I need this to work this way cause I can’t change people’s habits.

    Any help would be great,

  2. #2
    Valued Forum Contributor saravnepali's Avatar
    Join Date
    01-14-2019
    Location
    Sydney Australia
    MS-Off Ver
    2010
    Posts
    447

    Re: Pasting Protected cells

    Do you have the sample workbook, see the yellow ribbon on the top of page for instructions.
    If you think someone helped you, click on the "* Add Reputation" as a way to say thank you.

    If your problem is solved, go to Thread Tools and select Mark This Thread Solved

+ 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. Writing Code to Allow Pasting Over Protected Cells
    By kmk007 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 09-04-2018, 06:32 PM
  2. Copy & pasting cells with a drop down in a protected sheet
    By Puddlerunna in forum Excel General
    Replies: 3
    Last Post: 10-17-2014, 08:51 AM
  3. keeping cells locked and protected when copying and pasting
    By Lynne...... in forum Excel General
    Replies: 1
    Last Post: 08-21-2013, 07:42 PM
  4. Replies: 5
    Last Post: 07-15-2013, 03:57 AM
  5. Pasting into a Protected Worksheet
    By cgraeter in forum Excel General
    Replies: 2
    Last Post: 08-24-2012, 06:58 PM
  6. Pasting to Protected Cells in Xl2000
    By -VMill in forum Excel General
    Replies: 3
    Last Post: 08-17-2006, 10:35 AM
  7. [SOLVED] Protect unlocked cells in a protected worksheet from cut/pasting
    By Jerry NeSmith in forum Excel General
    Replies: 0
    Last Post: 11-29-2005, 05:10 PM

Tags for this Thread

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