lock cells

Hello, i have a problem with a subrutine. I did a subrutine to lock a specific range, but there are locked cells where i can write. If i look in format cell, I can see that the cell is blocked. So, I'm looking something to solve this issue, any solution? Thanks in advance. L.

Hi! Please help me woth the following problem (it starts with B2): <tbody> Contract no. Date Today Partner company Merchandise Shipping date Adjustments Etc.1 Etc.2 Etc.3 Etc.4 Etc.5 Etc.6 Etc.7 1 2014.02.12 2014.09.18 XYZ Inc. Books 2014.02.26 No 1 2 3 4 5 6 7 2 2014.03.13 2014.09.18 ASD...

Hi, Probably an easy one. I have two cells: C4 & C6. IF someone enters in either cell, I want the other cell to be locked and have a simple sum formula in (=SUM(D4,D6,D8)) So if someone enters 100 in C4 - C6 will be locked and have a Sum formula, if someone enters in c6, c4 will have the...

Hi, I have a cash report template that needs the page to be locked, with certain cells unlocked for data input. i need the unlocked cells to be able to be locked after the data is inputted. Throughout each day there will be four different times that data will be entered into the spreadsheet...

Hi everyone, I have a problem: I have an excel file that is shared by a number of people: First is filled by one person and then validated by some others (with their names in a combobox and password). Whenever the last person validates (column F), I would like to block the entire row (A:AF)...

I have created a spreadsheet in which all the non-data-entry-cells have been locked and subsequently protected with the 'Protect Sheet' and 'Protect Workbook' buttons. So far, so good. However, I want to enable specific users to be allowed to edit a specific area without unlocking the entire...

Good day,</SPAN></SPAN> I would like to lock cells that have got formulas inside but that is not possible as those cells are hidden or shown through a Visual Basic code and so when I lock those cells and then apply the Visual Basic code to hide or show the same cells the following message...

I have a workbook that has many columns (A to BH). All of the cells from A3:BG2383 are locked and the whole column BH3:BH2383 is unlocked ( I need people to input info there). Is there a way that I can protect every cell except for the cells in column BH but still be able to filter and have...

Dear Pro, I want to lock/unlock 2 cells depending on other 2 cells value Suppose...... My cell is a1, b1, c1, d1 The logic is If a1 and d1 value are greater or smaller than each other then b1 & c1 remain locked But If a1 and d1 value are same then b1 & c1 will unlock. Note plz... I'm totally...

First of all, I am very very geek for VB codes, so please excuse my poor coding attempts:( let me explain what I want to achieve. I have cell A1, which has two text values, "yes" or "no".(by data validation) Now if value "no" is selected, then I want cells A2:A6 locked and content cleared...

Hey All, A while back I used a vb I found here to lock cells that have been edited and it works great; I was wondering if there is anyway to add a comment with the date and time of the entry. The code I use is below Private Sub Worksheet_Change(ByVal Target As Range) Dim Answ As String...

I've a VBA situation if somebody can help me up with, I have a work book work several sheets ... All I need is when a user edit in a sheet and then click save all the cells ranging from A1:O30 in this active sheet will be locked All the sheets are already password protected Thanks again for...

To be more exact I have a formula set to auto populate cell A2 with data that is entered in cell B1, and cell A3 with cell B2 ect... I want the cell in column A to lock any time its value is equal to the value in column b on the previous row. I'm new to VBA and cant work my head around on...

Hello everyone. I want cells to be automatically be locked, based on a value of another cell. If there is no attendance: Lock cells 'test score, result, re-test score and re-test result'. If there is attendance: Unlock cells 'test score, result, re-test score and re-test result'. BUT: If the...

Hello, I'm looking for a way to have excel cells lock after an entry is made. I need it to work on several worksheets. I'm creating a file that will have a worksheet for every day of the month and the file will be for one month (31 Sheets). Each sheet is named 1-31 respectfully. I will have 6-8...

Hello all, I'm somewhat new at this VBA stuff so any help would be great. Here's what I'm trying to do. Have a cell be locked when something is entered into it so the user couldn't change the data once entered. I was able to get a code that does this and even gives you a pop up box prompting...

Hello all, I'm somewhat new at this VBA stuff so any help would be great. Here's what I'm trying to do. Have a cell be locked when something is entered into it so the user couldn't change the data once entered. I was able to get a code that does this and even gives you a pop up box prompting...

I have a row of data in cells A5 to P5. When a date (ie Feb 26 2013) is entered into cell Q5, I want the whole row to be locked. Need to do this for a complete range of cells (rows 5 to 500 for example). I need to use VBA, but am not sure of the wording. Any ideas please.

I need to know how i can lock formulas in certain columns. As of right now I have the code below to list things through an input box. In columns E9:E30,F9:F30,J9:J30, and K9;K30 I have a formula than needs to me locked. Is there anyway I can write in my code to lock it without a password? Sub...

Hey All, I am looking to have an excel sheet that many users will have access too. Is there anyway to lock information on the sheet after each person has put in their own data? I know you can lock cells and then protect the sheet, but by doing this, those that enter information after the first...