+ Reply to Thread
Results 1 to 1 of 1

I want to prevent the copy funtion for a range of unlocked cells in protect w/s

  1. #1
    Registered User
    Join Date
    10-29-2011
    Location
    Orlando, Florida
    MS-Off Ver
    Excel 2010
    Posts
    6

    I want to prevent the copy funtion for a range of unlocked cells in protect w/s

    I have a protected worksheet with two ranges of unlocked cells. These unlocked cells are for user input. The unlocked cells also have drop down list/ data validation. I want the user to use the drop down list however I do not want the user to be able to copy and paste within the unlocked range of cells. Seem like a few months ago I found a thread dealing with this issue and now I cannot find.
    Last edited by excel1z008339; 12-19-2011 at 01:13 PM.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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