lock after entry

Hello all, With a lot of help from this forum I was able to get my button working correctly on my sheet however I am hoping to add one addition that I hope someone can help with. We currently have a spreadsheet which we use to track all incoming material. The first 7 columns are unlocked...

Hi, I have a spreadsheet which allows users to mark there attendance in the office on a particular day. However, there is a condition where if a certain person is coming in to the office, people sat next to them cannot come in same day and this applies multiple times. I have done conditional...

Hi, I've searched around and tried different scripts online but none worked in my case. I'm making a break list for the team at my new job. The purpose is for employees to double-click on 1 cell, have the current time input, go on break, come back, double-click on a 2nd cell, have the current...

Hello! Please help me out if you can.... This is my formula: =IF((G9)="x",(TODAY())," ") It currently will add the date to the cell with this formula in it when i enter a X into cell G9 and and the formula cell will be blank with nothing in it. I access this file almost daily and i want to...

Hello Forum, I've searched quite a bit on this topic but haven't found anything helpful to my needs so far. I'll organize this thread in headers to help you find things more easily. What I Want to Do is This: Once data is entered in both K and L columns, I want to lock the row which the data...

Hello I am in desperate need for help with this, so any answer would be really useful! I have two worksheets, lets call them Worksheet1 and Worksheet2. Worksheet 1 is a sample formulary with a reset button, so that everytime you fill it and then press the button, a pdf of it is created and the...

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

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