lock cells based on range

Hello, I have the following code to lock the entire row, if the cell selects Yes, but how can I just lock the row from column a to Cd if cell.value is yes. I also then want to say if cell.value="No" , unlock the row and if it's "" do nothing to the row. Private Sub...

Hey gang, I have developed an excel template that my company can use to calculate and format their KPI stats. My company desired that the presentation include a header and footer that were Word specific and outputting to PDF. So originally this process involved copying the cells from the Excel...

Hi guys, I am an excel savvy person, but not too expert like VBA or macro programmers. As such, I need some help on figuring out how to lock certain portions of my worksheet upon a click of a button. Imagine a 30-day calendar spread page. I need to have 30 buttons which will enable the user...

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 Im new to this forum so hope this is the type of question. I have monthly workbooks which i use to verify data from a number of sources, most i have macros to import from supplier spreadsheets. My problem is one field has to be manually added by someone in another department. They need 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...

First of all, I am very very geek for VB codes, so please excuse my poor coding attempts:( let me explain what I want to achieve. I have cell A1, which has two text values, "yes" or "no".(by data validation) Now if value "no" is selected, then I want cells A2:A6 locked and content cleared...

Hi There, I have an excel sheet that currently locks all cells except for the ones that allow user entered/selected data (drop down list). I have it set up that if previous cell is blank interior color of that cell is black, if previous cell is not blank then interior color is white. What I am...

Hi, I am hoping someone can help me otherwise I may cry, I have a spreadsheet that has number between 1-20 entered in every cell in column B all the way down to row 15,000 I need to program something in VBA that will look at each number and then lock a certain range in that row based on that...