+ 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
    1

    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
    Forum Contributor saravnepali's Avatar
    Join Date
    01-14-2019
    Location
    Nepal
    MS-Off Ver
    2010
    Posts
    174

    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)

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