protect cells

  1. A

    Protecting a Worksheet

    Is there any way to protect a set of columns in a worksheet and still allow users to add rows or cut and paste rows without un-protecting those cells first? I have a form that needs to be used by several departments and everyone is worried about the other messing up their work, but the document...
  2. I

    Sequencial validations in adjacent cells

    Hello all, Below please find the current code I am using to validate my values. Right now I have that upon entering a value in a cell it validates if it is between a certain range given by values in two cells, display a message and regardless if data valid or not locks the cell. What I...
  3. M

    Secure a row when trigger cell is populated.

    I have a variety of spreadsheets I would like to apply this to so specifics are difficult. What I'm trying to write is a method to take all of the information in a row, change any formulas in the cells to hard data, then protect the whole row when a certain cell is populated. The trigger...
  4. B

    Lock individual cells

    I want to protect individual cells in a sheet. I am working on a shift report for my place of business and want to lock certain cells so that the staff are not able to make changes to some cells but are required to enter data in other cells. Therefore I do not want to protect the whole sheet. I...
  5. W

    Conditionally protecting a cell if it has a certain value

    Hi all, first post here. i'm Wonky1 from winkywankywoo (lol?), and although i've had a little experience with Excel, i'm a complete novice with vba. Using Excel 2007 and Windows Vista, i've been trying to find a way of temporarily protecting a cell if it has a certain value, until a different...
  6. M

    lock certain cells

    I have a price worksheet with drop down menus. the salespeople can fill in all data necessary and it will calculate pricing and sales tax etc. the problem is that they can also change fornulas by typing over a formula. how do you protect certain cells but still allow functionality <input...
  7. S

    Unlock entire row - condition

    Hi...want to know.. If any cell in Column "A" has any text, then unlock that entire row for editing. For example, if cell "A3" has text, so All I want that the entire row 3 to be unlocked for editing.
  8. 4

    Help protected cells within shared workbooks

    I am working in MS Excel 2007 using compatibility mode. Is there someone that can give me step by step instructions to protect individual cells within a shared workbook. These cells that I am trying to protect are linked to other workbooks. Thank you in advance.
  9. T

    Protecting a worksheet

    I have created a worksheet that is controlled entirely by buttons and userforms. How can I protect it so nobody can change the worksheet name and/or alter the cells/rows manually? The userforms will change/delete/insert rows and information though...
  10. A

    Locking / protecting a cell based on a value in another cell

    Dear all, I am busy making a database from a questionnaire in Excel and I want to be able to avoid data entry in a certain cell (to avoid data entry mistakes). For example: Colomn A contains a 1 (TRUE) or 2 (False) value as reply to a question if the family has children. Colomn B then...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top