unlock

Hello Community, i have been for a long time viewer and thanx for many solutions that i have found! My problem now is that i have a range of cells lets say $A$1 to $E$5 in which i want every cell to be locked except 3 which addresses are mentioned in cells $A$10 , $A$11 , $A$12 in the format of...

Hello, I've an issue on how to change other cells into "Lock" based on a specific value. By default, cells within columns B to F was locked, if relevant row's Control value = "Yes", the same row's Column C, D and E will be unlock. For example, if Cell A2 = "Yes", then Cell C2:E2 will be...

I am trying to lock only certain cells in the worksheet. I have tried several different codes, and they work, except for the fact that, rather than locking only the 6 cells that I want locked, lets say, A1, A2, A3, A4, A5, & A6, the whole sheet ends up being locked. I have watched videos on it...

HI I am trying to loop through some (not all) boxes on a user form to lock/unlock them when a particular command button is clicked. The controls in questions all have names that start with "POinv" and then a number. I have the following code but it's not working as it doesn't seem to like...

Hey guys, I need your help Problem: User choose a Location, after his decision, it is written in a cell. There are several tables for each Location. First they are all hidden, but if you have choosen a Location, the specific Location table is displayed, all others arent. This should be down...

Was wondering if I could get some help on VBA. I've modified some code from the following link: http://www.mrexcel.com/forum/excel-questions/456990-locking-unlocking-cells-based-value-another-cell.html I'd like to unlock/lock column E based on text in column H. The spreadsheet is protected...

I am trying to figure something out and I realized that it will take a little VBA to complete my request. I have a cell that is unlocked, Sheet2:A1, by default because the cell in Sheet1:A1 is blank. If someone puts text in Sheet1:A1 then I want Sheet2:A1 to lock where it can't be changed...

I have two workbooks "Checkbook.xlsm" and "TaxReporter.xlsm". The Checkbook has all cells locked and uses VBA forms to accept input, verify information and insert rows. There are twelve monthly spreadsheets labeled "January" through "December" with named ranges named "Payroll_Jan" though...

Greetings, I am working on a fairly complex model with lots of formatting and lots of checkboxes. I need a quick way to get all the cells with a checkbox unlocked so when I protect the sheet they are usable. I have lots of merged cells so just highlighting a column is a non-starter. Any help...

I have a <acronym title="visual basic for applications" style="border-width: 0px 0px 1px; border-bottom-style: dotted; border-bottom-color: rgb(0, 0, 0); cursor: help; color: rgb(51, 51, 51); background-color: rgb(250, 250, 250);">VBA</acronym> that is used to highlight cells in my worksheet as...

Hello everyone, I have a protected worksheet with most cells locked and some that are unlocked. I also know the password to unlock the sheet. Does anyone know the VBA code to monitor a cell(B29 in my case) and if it has a value of 6.00 or more than it will unlock cell B34? Seems simple...

I am using excel 2003. I have locked and unlocked cell on the same sheet. I have protected the sheet. I can enter data into the unlocked cells. But I can't BOLD the text in the unlocked cells. Is there anyway to allow the user to bold the text in the unlocked cells in a protected sheet...

I've been wrestling with the best way to do this for awhile. Requirements: 1) I have a single spreadsheet with existing data (one row per person) that needs to be updated regularly. 2) There are 4 different types of users: Group A, Group B, Group C, and Admin. 3) Column C in each row identifies...

Hi I have a macro that opens up a number of spreadsheet and then does some work on them, however all of these spreadsheets have passwords on which i have to type in manually every time each spreadsheet is opened. Is there a way that i can hard code the password in to the code or get the user...

Hi All,<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" /><o:p></o:p> <o:p></o:p> I have a workbook with a sheet that is protected, and being the idiot that I am I have forgot the password :confused:<?xml:namespace prefix = v ns = "urn:schemas-microsoft-com:vml"...

Hi!, I been working on a pretty confusing excel format, but on somehow ~~' made the big mistake than any can ever make... Forgot the pass... Can any one help me to figure it out; or if it's possible break it down, and then explain me how you did it. I don't know how to use VBA... Already try to...

I have a worksheet that is password protected and I only allow users to select and enter in cells that are unlocked. I want to allow certain users (Managers) to enter a password for a range of cells that would unlock certain cells and allow them to enter into the cells. (it's a worksheet that...

One of my spreadsheets is in a safety mode that makes it very slow to open or close. I think this happened during an interrupted save. Can anyone tell me how to cancel or clear this safety mode?

Hi All, my apologies for bothering you all again, but after a few days of struggling to find a way to pull data from a row into a userform based on a search value being found in column A, I've decided it may be easier to unlock just a single row for editing based on that search value..but is...

Trying to write a code that will accomplish the following: 1. If cell "H16" is "Yes" then unlock range E47:E53 2. If cell "H16" is "No" then fill range E47:E53 with zero's and lock. Given-working on Sheet5, and let me know if the range E47:E53 needs to be normally locked or unlocked. Also...