locked cell

Hi all I have a dilemma. Can't find a solution. I have a row with 5 columns. A2 has a name, B2, id, and c2 d2 & e3 will have data. The last cells the data then looks up in another chart and find the name and input the data in the required cells. Then A2 name will change so data in C2,D2 & E2...

Hi there, I Wondered if this was even possible and i'm newish to VBA: Notes: Column J is a data validation list and the below is from A:W ISBNCustomerDivisionTitleAuthorPub dateRRPFormatImportant Do Not TouchPromotionAdditional infoImportant Do Not TouchChart DateMod BreakStorebaseDiscount...

Is there any way where you can show the input message that has been placed on a cell that is locked/protected? Basically I want the message for the cell to show up but dont want the user to be able to change it. thanks in advance

Hello, I am working on a spreadsheet with VBA and am trying to make sure the cells are locked AFTER data is entered. What is happening now is that I can go in and edit the data as much as I want to but the moment I delete or clear the data the cell locks. This is quite the opposite of what I...

Cell B8 can be blank, Yes or No. When B8 is Yes, I need my data validation list to appear in fields G28:G35. This is simple and I have my listed named Status. When B9 is No, I need N/A to automatically populate in fields G28:G35. I also need these cells locked. I found some VBA help topics but...

Smart People, This may be the dumbest question ever but, how do I lock a cell so someone can not edit the data or formula but still allow them to copy and paste the cells? I can easily lock a cell but then you can't copy it. People need to be able to paste it into a powerpoint slide. Thanks...

Hello, I wish to lock a fill/ background colour to a range of cells, and keep it locked in, regardless of the data I input, whether the cell is blank or not, and even if other cells are directly copy/pasted onto it. The ranges are: A1:C25 to be Red Fill A26:C50 to be Green Fill A51:C75 to be...

I am creating a form that the first person only needs a little access to but they need to see some fields but no rights to them. The next person needs to see what they entered but should not be allowed to change it. The last person needs full access. To protect the cells I am only using three...

Hi Excel Experts! I wonder if I can have a macro code which will make some contents of my file be accessible (can be modified) to others if only the macro is enabled. I want to lock my file (all cells) to prevent others to change some of its contents. But since Microsoft disables the macro by...

I am relatively new to Excel, I know the basics but that is about it. Basically what I am doing is creating a cash sheet to record totals from tills, and than at the end do a tally, but I've made it so that once a cell has been edited, it cannot be changed, this is great so numbers cannot be...