+ Reply to Thread
Results 1 to 2 of 2

Copy Protection from One Sheet to another

  1. #1
    Registered User
    Join Date
    02-23-2016
    Location
    Mauritius
    MS-Off Ver
    MS Office 2013
    Posts
    2

    Copy Protection from One Sheet to another

    Hello there, im currently trying to copy and paste a protected cell from one sheet, suppose sheet 1 to a cell in sheet 2. The problem is that i have to retain the protection whilst doing so and apparently when copying the protection is lost. Is there any way of how i can copy and paste the data WITH the protection or any vba code which can be applied to carry out this task?. Thank you.

  2. #2
    Valued Forum Contributor
    Join Date
    01-08-2011
    Location
    Portsmouth, England
    MS-Off Ver
    Excel 2007 to 2016
    Posts
    456

    Re: Copy Protection from One Sheet to another

    If you just do a straight copy/paste, the format (including the protection) will be copied to the destination cell.
    Excel is a constant learning process and it's great to help each other. If any of us have helped you today, a click on the "reputation" star on the left is appreciated.

+ 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. [SOLVED] How to Disable Cell Merging on Single Sheet (without using sheet protection)
    By nuttyengineer in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 07-06-2016, 07:56 PM
  2. copy & paste protected sheet with protection
    By rana19 in forum Excel General
    Replies: 4
    Last Post: 10-06-2015, 08:44 AM
  3. Replies: 0
    Last Post: 09-13-2013, 10:42 AM
  4. copy and paste fix to data validation undone by sheet protection
    By scorpion99 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 01-10-2013, 03:25 AM
  5. Excel 2010 - Copying sheet with protection manually, protection stays... not with VBA
    By AdamParker in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 03-02-2012, 12:38 PM
  6. Copy Sheet Protection to a new sheet in excel
    By Lisea123 in forum Excel General
    Replies: 0
    Last Post: 07-15-2011, 01:16 PM
  7. Replies: 4
    Last Post: 09-27-2005, 03:05 AM

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