lock

I have a zillion named ranges and I need to go through the list and lock them. But I am getting an error "Unable to set the locked property of the Range class." Suppose the range is named LockMe1 then I am trying to do Range("LockMe1").Locked=true Putting this in a loop and cycling through...

I have an application that I made in Excel. I have 2 subs in a module, one to un-protect the active sheet, another to protect. One of my pages has some cells unlocked. When I call the two subs to protect/un-protect, everything works just fine. In another sheet however... everytime I call one...

I am working on a ranking workbook. At the beginning of the season I rank a hole bunch of in information on a sheet. Once there ranked I want to lock in those number until the next year when I want to rank them again. How can I make this happen. Thanks in advanced.

Hi I wish to do this in VBA. I have a set of data running from row 1 to 200 and column A to E. I wish to have a lock row button, this means that every time i click on one of the cell in column C, the row of the cell will be locked after i click on the button. Eg. I click, 1st: C3 2nd: the...

Is there a way to create a lock and unlock button. This mean that every time I click on one cell, then the lock button, the whole row will be locked. And to unlock i just have to click on one of the cell in the row then the unlock button. Lock and unlock button is to prevent the data from...

Hi I just noticed that excel will lock a range if the range was selected from different file but if the range was selected from different sheet then excel would not lock it. What is behind that? I am using vlookup =vlookup(A1,sheet2!B2:D10,2,false) <<--- from different sheet, same file...

Good Morning. Thank you for coming into my thread. :) What I am trying to figure out is if I can lock the rows to a certain reference cell. I will do my best in explaining. Please hear me out. I have two sheets in which information is inputted through rows. Sheet1 Names|Item|Item2|Item3|...

Hi all. I would like to be able to insert a logo either as a picture or watermark and lock it down with a password. Is this possible without vba?

Good Morning, i am wondering how i can lock my charts/graphs so that the axis cannot be changed. I can lock the cell with the formulas, but the axis can be changed. Any help would be appreciated. Have a nice day Brown

How can I hide the formulas in certain cells, still show the value, and not have to lock the sheet?

Good morning, The spreadsheet I am working on needs the community's assistance. The goal would be to Lock 3 cells in the same row IF any alpha-numeric character is input in another cell. For example, if the user marks cell B12 - then lock cells C12, D12 and E12; if the user marks cell C12...

I would like to apply the macro below only to cells B3, B6, B7, B8 leaving other cells open to editing. Private Sub Worksheet_Change(ByVal Target As Range) Dim bl As Range ActiveSheet.Unprotect Password:="1234" For Each bl In Target If bl.Value <> "" Then...

I need to lock certain cells in a chart however I also need to be able to insert rows into this same chart. Is this possible. Example: <tbody> Item Qty Price Stapler 2 $50 </tbody> Take this chart as an example. I have locked the price cell as it contains a formula I do not want...

Hi I need a way to lock cells permanently, so not even I can get back into it. e.g. Lock cells A1 to A10. I can't know the password. I can't alter the VBA code to get back in. Is this possible? Cheers!

i want to lock selected cells A1:A50 D5:D50

Hello, I'm trying to create a worksheet_change macro in where if there is an "x" in column k cells n:ae in that row would lock. All the data is currently in a table so I don't want to have to put in a valued range ie: k1:k9 but the table starts at row 9 and then changes per worksheet but the...

I have a document that I want to maintain the cell height/width, and when I send it to a colleague for review, he keeps changing the rows and columns to be varying sizes. He needs to be able to make other changes to the cells, such as text or background color, so I don't want to completely...

I made a spreadsheet with 40 rows and 10 columns. Column "A" is a list of peoples names. Columns B:I are check boxes that are assigned true/false values somewhere else in the spreadsheet.. Right now the check boxes are floating boxes. Is there a way to lock a checkbox to an individual cell? When...

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

I've built a tool for folks at work that they can use to enter some data via Excel and have it generate a deck of powerpoint slides. Each slide includes a bunch of bullet statements. I've taken the approach of putting a textbox on the Excel sheet that fits the format of the slide. So they can...