+ Reply to Thread
Results 1 to 4 of 4

Protecting Cell Ranges

  1. #1
    Registered User
    Join Date
    11-29-2012
    Location
    Madison, WI
    MS-Off Ver
    MS Office 2010 (Excel, Word, Access)
    Posts
    72

    Protecting Cell Ranges

    I'm trying to protect *parts* of a spreadsheet that contain formulas I use that work with data provided by other users. I've gotten the columns that my formulas are in protected, but I just discovered that if somebody selects an entire row they can apparently still delete the contents of my protected cells.

    Is there any way to "lock" regions that will prevent this?

    Thanks in advance for any help.

  2. #2
    Forum Expert Logit's Avatar
    Join Date
    12-23-2012
    Location
    North Carolina
    MS-Off Ver
    Excel 2019 Professional Plus - 2007 Enterprise
    Posts
    5,552

    Re: Protecting Cell Ranges

    https://support.office.com/en-us/art...3-042a5f2cd93a

    Also do a search for :
    excel protect cell or cell ranges

  3. #3
    Registered User
    Join Date
    11-29-2012
    Location
    Madison, WI
    MS-Off Ver
    MS Office 2010 (Excel, Word, Access)
    Posts
    72

    Re: Protecting Cell Ranges

    Tried that, and it doesn't seem to be protecting everything it should.

    Also, sorry about the double-post. I'll be deleting this version of the thread shortly (it told me it failed to post the first time.)

  4. #4
    Forum Expert Logit's Avatar
    Join Date
    12-23-2012
    Location
    North Carolina
    MS-Off Ver
    Excel 2019 Professional Plus - 2007 Enterprise
    Posts
    5,552

    Re: Protecting Cell Ranges

    Server problems. They are in the process of moving the forum to a new server in hopes of clearing up many issues.

    Thanks for the Add Rep.
    Last edited by Logit; 02-03-2017 at 01:34 PM.

+ 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. Replies: 1
    Last Post: 01-24-2017, 04:10 PM
  2. [SOLVED] Protecting Cell Format but allowing cell data entry
    By telcocook in forum Excel General
    Replies: 3
    Last Post: 10-10-2014, 04:06 PM
  3. Autolocking cell after entering number and protecting the cell from editing
    By batya in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 08-08-2014, 06:22 AM
  4. protecting certain cell ranges with VBA and button
    By James__S in forum Excel Programming / VBA / Macros
    Replies: 19
    Last Post: 01-29-2014, 02:10 PM
  5. Protecting tabs and protecting sheets
    By jimstrongy in forum Excel General
    Replies: 0
    Last Post: 01-31-2012, 11:27 AM
  6. [SOLVED] protecting formulas with named ranges
    By Robin in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 09-04-2005, 11:05 PM
  7. Howto: Protecting specifig Ranges for inserting Rows
    By MarkusPoehler in forum Excel General
    Replies: 1
    Last Post: 05-20-2005, 03:06 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