lock cells

Hi there, Wonder if anyone can help me with this issue. I've written a piece of code to lock cells AND unlock cells on a condition. For example if D5 = 1, users will only be able to input into the first group of cells (when protected) so the rest will be locked. This is purely to allow users to...

Hello! I am trying to set and lock the values in two cells when the user selects a particular value from a drop down list in another cell. Each of the cells have data validation lists as well and they are all different. Here is what I currently have but it errors on setting the value on...

I'm completely new to this and I really need some assistance. I have a workbook with multiple worksheets that are used to track production for my employees. Each worksheet will need to be protected after they are completed by the employeess so that changes can not be made after the fact. I would...

Hello I have a workbook (excel 2007) and would like to make sure that users need to enter a password when they open the file to be able to edit certain cells. Currently without a macro, if someone has the password, they can unlock the cells and edit the document, but if they forget to...

Hello all, I am getting more and more familiar with VBA. Since I took some courses on Java I felt quite comfortable with my level of knowledge, until I had to combine different functions. Bottom line I am looking for: Upon a decimal number is entered, to be validated to fall between a...

I have a column filled with 17 character identification numbers. I need the next column over to automatically replicate the first 8 characters from the same row in the column next to it, and also to lock this column so that the data can not be modified??

Hi guys,... I am trying build a database kind of thing, and i have 2 doubts regarding this, hope you guys will help on this.. 1. Is there possible to create time stamp,.. when the record is entered. Tried something with now() function A1= if(B1>0, now(),"").. A2, A3, so on ..but if something...

I have several cells that are linked to a word document and they work great as long as I don't add row or columns or change the original location of the cell. Is there a way that I can add a row or a column in the excel worksheet without throwing off all my linked cells? Eg. I have cell D129...

Hi there, first post on MrExcel!! Sorry if my explanation is a little long-winded. So I have a s/sheet with about 160 columns. I have about 57 columns spread out throughout these 160 columns that I want to lock, so they can't be edited when I share this with colleagues. I have done the...