+ Reply to Thread
Results 1 to 5 of 5

Protection: Making Cell Values Copy-able but not Changeable?

  1. #1
    Registered User
    Join Date
    09-01-2010
    Location
    Bay Area, CA
    MS-Off Ver
    Excel 2007
    Posts
    14

    Question Protection: Making Cell Values Copy-able but not Changeable?

    Hi there! I have a dilemma I just cannot figure our how to solve. I need to make an excel document easy-to-use for the masses (aka company I work for) that calculates stuff based on input they give into a column. The problem is that I can't allow these lovely people to change the formulas (in other columns -- the ones that calculate based on values the user enters in the first column), or they will end up ruining the document for everyone. My problem is that I do need them to be able to select the CELL VALUES to use in our reports, and there can be up to 20,000 rows of data they'll need. Is there anyway, programmatically or otherwise, to make these sheets so that the formula cells are un-editable but still selectable to copy their resulting values? (If it's just not possible, I'll have to live with that, but I wanted to make sure, and figured if anyone would know, it's you guys!!) Either way, thanks so much for your help!

    ~CR
    Last edited by lowprofile; 11-14-2014 at 12:24 PM.

  2. #2
    Forum Expert Kenneth Hobson's Avatar
    Join Date
    02-05-2007
    Location
    Tecumseh, OK
    MS-Off Ver
    Office 365, Win10Home
    Posts
    2,573

    Re: Protection: Making Cell Values Copy-able but not Changeable?

    Yes, set the option to allow it when you Protect the sheet.

  3. #3
    Registered User
    Join Date
    09-01-2010
    Location
    Bay Area, CA
    MS-Off Ver
    Excel 2007
    Posts
    14

    Re: Protection: Making Cell Values Copy-able but not Changeable?

    The only option I see (in Excel 2010) is to NOT allow the users to select any locked cells. This means they cannot even copy their values, correct? I mean, how can they if they can't select the cells? Is there an option I'm missing?

  4. #4
    Registered User
    Join Date
    09-01-2010
    Location
    Bay Area, CA
    MS-Off Ver
    Excel 2007
    Posts
    14

    Re: Protection: Making Cell Values Copy-able but not Changeable?

    Ugh, nevermind. I didn't understand that once the sheet is protected, even if I've put that they can select locked cells (to copy the values somewhere else, for example), they cannot change the contents. I'm an idiot. Thanks for your help!

  5. #5
    Forum Expert Kenneth Hobson's Avatar
    Join Date
    02-05-2007
    Location
    Tecumseh, OK
    MS-Off Ver
    Office 365, Win10Home
    Posts
    2,573

    Re: Protection: Making Cell Values Copy-able but not Changeable?

    Select locked cells is the first option in the Protection list of options. Most people have that dialog show up with that option scrolled up.

    You can code your macro to modify something to unlock some range if needed. Kind of defeats the purpose but needs vary.

+ 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. Need help making a macro to copy range of values based on cell values.
    By zolton in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 06-23-2013, 08:58 AM
  2. Replies: 0
    Last Post: 12-10-2012, 09:06 AM
  3. making a macro to pull a spreadsheet from a changeable link
    By cebubb in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 11-29-2011, 08:31 PM
  4. Making cell values correspond with Drop down List values
    By jrcream in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-29-2008, 03:14 AM
  5. Searching Based On Contents Of Changeable Cell
    By belfast-biker in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 10-04-2006, 04:26 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