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...
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...
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...
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...
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...
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...
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.
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.
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...
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 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.