+ Reply to Thread
Results 1 to 6 of 6

paste from unlocked cells to unlocked cells on protected worksheet

  1. #1
    Registered User
    Join Date
    09-27-2014
    Location
    New York City
    MS-Off Ver
    2010
    Posts
    32

    paste from unlocked cells to unlocked cells on protected worksheet

    I just want to paste from a range of unlocked cells to another range of unlocked cells on protected worksheet. Is this possible at all ?

  2. #2
    Registered User
    Join Date
    03-12-2015
    Location
    Sofia
    MS-Off Ver
    2010
    Posts
    1

    Re: paste from unlocked cells to unlocked cells on protected worksheet

    In a protected sheet you'll be able to select and paste only if the protection allows you to Select unlocked cells

  3. #3
    Registered User
    Join Date
    09-27-2014
    Location
    New York City
    MS-Off Ver
    2010
    Posts
    32

    Re: paste from unlocked cells to unlocked cells on protected worksheet

    Sorry breakingwaves, all is not what it seems. After further testing and investigation, I discovered that
    I unintentionally omitted some useful information from the problem description.

    1. There are three elements to this problem, a) worksheet protection with some cells unlocked for user input,
    b) a "Private Sub Worksheet_SelectionChange(ByVal Target As Range)" macro to manipulate cells in another
    worksheet when an unlocked cell is selected, and c) the standard copy of one unlocked cell to another
    unlocked cell.
    2. With (a) and (b) in place as described above, only the copy (Ctrl+C or right-click followed by clicking "Copy")
    seems to function properly but the paste (Ctrl+V or right-click shows greyed-out "Paste") does not function.
    3. If thw worksheet is unprotected OR the "Private Sub Worksheet_SelectionChange(ByVal Target As Range)" macro is
    removed, Copy and Paste of the unlocked cells functions as expected. But the combination seems to be causing
    the problem

    Here is a copy of the spreadsheet. Any ideas would be greatly appreciated (I'm really scratching my head over this)
    Attached Files Attached Files

  4. #4
    Registered User
    Join Date
    09-27-2014
    Location
    New York City
    MS-Off Ver
    2010
    Posts
    32

    Re: paste from unlocked cells to unlocked cells on protected worksheet

    This issue has turned out to be specious. breakingwaves is absolutely correct. Thanks much.
    After starting over with a fresh spreadsheet, everything worked. Apparently, I had inadvertently
    tripped myself up by creating a "Fourth" element to the situation that I haven't yet identified.
    Thanks again to breakingwaves and anyone else who spent any time on this thread.

  5. #5
    Registered User
    Join Date
    09-27-2014
    Location
    New York City
    MS-Off Ver
    2010
    Posts
    32

    Re: paste from unlocked cells to unlocked cells on protected worksheet

    This issue has turned out to be specious. breakingwaves is absolutely correct. Thanks much.
    After starting over with a fresh spreadsheet, everything worked. Apparently, I had inadvertently
    tripped myself up by creating a "Fourth" element to the situation that I haven't yet identified.
    Thanks again to breakingwaves and anyone else who spent any time on this thread.

  6. #6
    Registered User
    Join Date
    09-27-2014
    Location
    New York City
    MS-Off Ver
    2010
    Posts
    32

    Re: paste from unlocked cells to unlocked cells on protected worksheet

    This issue has turned out to be specious. breakingwaves is absolutely correct. Thanks much.
    After starting over with a fresh spreadsheet, everything worked. Apparently, I had inadvertently
    tripped myself up by creating a "Fourth" element to the situation that I haven't yet identified.
    Thanks again to breakingwaves and anyone else who spent any time on this thread.

+ 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] Find & Replace within Unlocked Cells in a Protected Worksheet
    By DaveyC4S in forum Excel General
    Replies: 4
    Last Post: 06-28-2023, 11:28 PM
  2. Cannot format unlocked cells in protected worksheet
    By wolfm in forum Excel General
    Replies: 0
    Last Post: 01-10-2013, 03:29 PM
  3. [SOLVED] How to lock previously unlocked cells on a protected worksheet
    By susuyesyes in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 12-07-2012, 10:28 AM
  4. Replies: 2
    Last Post: 07-20-2006, 09:05 AM
  5. [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

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