1. H


    Hello Friends, I am new to VBA and i have trying to set a code up that does the following. If values are entered in any given row of column F. all the columns in that given row will be locked and protected. Private Sub Worksheet_Change(ByVal Target As Range) Set Rng = Range("F2:F999999") If...
  2. L

    Lock filters

    Hi Guys. Is there a possibility in excel to lock the filters? Meaning that I do set up some filters for certain columns and I want prevent other file users to modify it ? Note - I do not want to lock cells to be edited, just filters. Or maybe is there a simple clever macro that would show a...
  3. D

    Lock Columns A, B & C, but Still Allow Rows to be Added or Deleted

    Greeting - is it possible to just lock columns A, B & C from being edited, but still allow rows to be added or deleted? I using Excel 2016. Many thanks in advance for any assistance.
  4. J

    Lock Formula Return Value

    Is there a way to lock the return value of a formula. I need my vlookup formula to return the value and leave it unchanged because the data range vlookup is pulling from will be deleted on a daily basis. Any and all help is appreciated. Thank you.
  5. M

    Auto Lock Workbook Complete

    Hello, I am new to this form and excel . i have one question I want to lock my workbook complete after specific date or time. Workbook Have 3 sheets all three sheets i want to lock down after some specific time. my sheet1 have formulas so i already lock few cells which have formulas...
  6. P

    VBA Row Lock

    Hi All, I've come to the conclusion that I don't know how to do this. I've tried to lock a row with a code but it appears to lock every row. For example; If I'm trying to lock Range ("B10:M10") but after I run my code it locks every row that has an entry. Very strange to me...
  7. N

    Lock all the controls in a userform

    Hello, I have a userform with many Textboxes, Labels, CommandButtons.... I need to lock all the controls when the userform Initializes Instead of locking each control separate, I found this code on google that works well if the userform doesn't contain any label, else if there is any label...
  8. S

    Lock progress chart to a specific cell

    Hi, I think this might be easy or just not possible. I am creating a training matrix for my company to drive competence and have started an excel document. The progress charts show progress and will help set targets. The problem I have is when I insert a new row, adjust size etc, all my...
  9. S

    Can I use VBA to Lock VBA where Password already exists?

    I made a careless mistake and left the 'Lock project for viewing' box unchecked and sent out copies of one of my models. A project password already exists. I had just unchecked the 'Lock' box for my convenience while I did some annual updates, but then forgot to check it again before sending...
  10. M

    protect conditional formatting

    I have a sheet that has a ton od conditional formatting. I need to let users add data in all areas, but want to lock all the conditional formatting and still be able t paste into the cells etc. Is there a way to do that?
  11. D

    where is properties window vba?

    hi, i cant find it? i pressed f4 and it's not showing. also, before it disappeared, it was "free flowing" and not locked as it usually is at the bottom left corner? how do i lock it? (first i need for it to show up, my first issue)
  12. P

    Lock listbox after CLICK event

    I have a listbox with code that runs after user makes a selection (clicks item). It's a Form Control (vs. ActiveX type). Right now, while the code runs (takes about 5 seconds to complete), user can immediately click another item on list and listbox selection changes (though click event doesn't...
  13. P

    VBA Lock and Unlock Cell Help

    I need a little guidance. I do not want to use Data Validation to restrict data entry in the cells as the warnings for accidentally typing will decrease productivity. I want the user to be able to select from the list in the Table column C and it lock the unnecessary cells so they can quickly...
  14. W

    Popup box asking for password to unprotect cell

    Hi, I have a excel sheet that is used to calculate staff hours and the sheet is protected with a password to stop people changing it. It has checkboxes and fields which add up/minus etc depending on what is chosen, something that has taken awhile to produce and something I am proud of. I've got...
  15. K

    Lock Ribbon

    Does anyone know if there is code to lock the ribbon so that none of the tabs can be selected? Or even hidden and locked?
  16. J

    Locking cells

    Hi, I have a spreadsheet with some formulas in to represent a receipt. I want to be able to lock the cells with formulas. I think this is easy enough. My trouble is I want to lock some cells to accounting GBP currency. basically so a figure can be entered but so that somebody cannot delete...
  17. M

    Newbie at Vb need help

    I have 3 cells that have a macro to change values via a command button and ctrl + R and ctrl + D. Those values change color as well with conditional formatting so you can see the change. How do I lock those cells with out getting a Vb error "1004". At which time I need to reboot pc. Basically I...
  18. T

    Lock form on a given time period from adding new records

    Morning from everybody! I have an electronic requisition DB that the production department uses to enter the parts needed on the shop floor. Warehouse people then print the req and take the parts down. This DB is open 24/7/365 I need to limit the time that production folks can issue new reqs to...
  19. C

    Lock a cell based on another cell's value

    Hi I am trying to lock a cell (A1) based on the value of another cell (A2) (ie if the other cell's value is above 0) to prevent users from entering data in that cell in A1 if A2>0 How do I do this ? Thanks for the help
  20. P

    Lock particular cells in a worksheet

    Hi, I am using excel for a survey which I will send out via email to respondents and want to - Prevent them from adding rows and or columns - Only be able to enter data in selected cells - Also write some rules/conditions that will appear with a prompt (i.e I ask respondents how they split...

Some videos you may like

This Week's Hot Topics