locked cells

I am trying to drag a formula across many columns, while maintaining the first two cells. However, I am having a problem locking the first two cells because once I select the range, it automatically adds the brackets for a Table, and I don’t know how to add a locked $ to that ($C$2:$C$100...

I have a workbook with multiple sheets that I need to be able to share with someone who will take over doing the results, but I am faced with a dilemma and hope there is a solution. So each sheet has 27 columns of data which are able to be edited and there are new selections added daily. The 25...

Hi, I'm trying to leave certain cells/functions open for user input, but keep running into a problem I can't figure out. I've been through endless forum threads, but none has been able to help me so far... I have a workbook with 4 sheets, two of which are VeryHidden and not relevant. The third...

Hello, I have a sheet that automatically updates based on information entered by the user. I need certain cells to be protected, and others not to be. I've tried the following script: sh2.Range("B2:D2").Locked = False sh2.Range("C4:D4").Locked = False sh2.Range("C5:D5").Locked = False...

Hello, I have followed the process of locking my worksheet then enabling the relevant columns to Sort using the 'Allow Edit Ranges' function. I unchecked the 'Select Locked Cells' option when protecting the worksheet so nobody can select the cells and edit them. However when I hide the...

We are currently using Excel 2007, The spreadsheet has a lot of different calculators involved and would like to protect the sheet and have only certain cells accessible. I created a form control drop down box that lists about 30 different vendors, the users would click on the drop down to...

Hi, I have a worksheet that I would like users to be able to sort and filter the contents of, but half of the columns are formulas that I would like to keep locked and half are open for editing. When I have the cells with formula 'locked' (via formatting the cells) the sort function doesnt...

I have a spread sheet that is Locked/Protected. I want to be able to unlock cell D10 based on the Value of cell C10. so if cell C10 ="Other" I want cell D10 to unlock. else then Cell D10 to remain Lock. thank You in advance

Hello, I have been lurking here for a long time and have learned much from all of you. Thank you!!! I have something that I haven't been able to find an answer to, so I'm hoping one of you can help. I have an estimate sheet where the mark up % fields ("G21,G26,H21,H26") are locked unless...

Hello, I have a template worksheet in which most cells are marked as "Locked" for protection (under format) while specific cells are left unlocked. Now I want to copy this specific arrangement of locked/unlocked cells (not the cell contents, just the protection status) onto many other sheets...

I have a spreadsheet that I pass around for others to fill out but they keep changing the format of certain cells from General to Text and it messes up some of my formulas. Is there anyway to lock these cells so that they stay General format and cannot be changed?

Hi, I have a very weird issue that I have never encountered before. I am trying to protect my worksheet by only allowing certain ranges to be editable. When I protect the sheet it indeed locks (almost) everything but there are a few ranges that are still accessible, which would be catastrophic...

HI EVERYONE I have the following code: Sub TextBox3_Click() Range("E3").EntireRow.Insert Shift:=xlDown Range("E3") = Range("E4") + 1 End Sub which is a macro so when a user clicks on this text box the macro is made to, insert an entire new row also whilst this occurs, as you can...

Is there any way to completely lock out a cell from a user deleting the formula/information contained in it? Even with the cells being locked and hidden on a protected sheet, all a user has to do is click on an unlocked cell and drag their selection into the locked cells. If they hit delete, all...

Hello all, I have this code that I am using: Sub completed() ActiveSheet.Unprotect "majinbuu" Range("E11").Select ActiveCell.Value = Range("A9") & " " & Range("E43") & " " & Date & " " & Time Range("E13:E41").Select Selection.Locked = True Selection.FormulaHidden =...

Hi All, I have a macro in a protected sheet that pastes an image into it. I want that image to be unlocked so it can be selected and copied. I know you can right-click and unlock the image after it has been created, but this cannot be done when the sheet is locked. My code is below and the...

I have protected a worksheet and enabled the auto filter, however while the sheet is protected I want to allow users to turn the filter on and off. Is there a way to allow this? Thanks,

I set up a worksheet for other users to calculate the tax consequences of different divorce settlements. The users enter the cells bordered in black. The cells bordered in blue return results and are the cells I want to lock (and to do this I need to protect sheet.) I want the users to be able...

After reviewing and experimenting with a few different suggested codes, I decided to post a thread to ask for help in cleaning up and solving my problem. I'm trying to lock the rows to the right of a target cell. The list is a reoccurring list of exact days and dates, followed by a weekly...

Hello Excel Experts, I have an excel sheet, which is protected. I would like to give the user the ability to select specific locked cells within a sheet while at the same time not allowing them to select other locked cells within the same sheet. Basically i have a small, cell-based calendar...